Time Elapsed In Hours Between Multiple Dates In Excel

I am trying to find a formula that works out the business hours between two dates in excel.

The business hours start at 09:00 and end at 17:00 and do not include weekends.

The spreadsheet is currently laid out in the following way;

A1: Start Time       -       B1: End Time   -       C1: Total Business hours A2: 2016-01-04 10:31:17   -  B2: 2016-01-06 10:02:14 

Is there a formula I can use that will calculate the difference in time (business hours) and display it in C2?

Replay

Category: microsoft excel Time: 2016-07-29 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.152 (s). 12 q(s)