Solved Time Elapsed in hours between multiple dates in excel

July 29, 2016 at 02:33:46
Specs: Windows 7
Hi,

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?

Appreciate your help!

message edited by Brown94


See More: Time Elapsed in hours between multiple dates in excel

Reply ↓  Report •


#1
July 29, 2016 at 06:11:57
✔ Best Answer
You may need to modify your sheet a bit, but see here:

http://www.cpearson.com/excel/DateT...

Any questions, let us know.

MIKE

http://www.skeptic.com/


Reply ↓  Report •
Related Solutions


Ask Question