Calculate the total hours and minutes between two dates, with business hours

[edved81]

I need to calculate the total hours and minutes between two dates mentioned in excel. i.e.,

Start date: 02-MAY-2015 07:00:00 PM
End Date: 03-MAY-2015 10:04:00 AM

The answer should be 01:04 h:mm.
Need to consider business hours, it should be from 09:00 AM to 06:00 PM.
Please help me on this.

 

[Khalid NGO]

Hi,
Can you check the following links having similar questions:
http://chandoo.org/forum/threads/calculate-business-hours.22689/

http://chandoo.org/forum/threads/ca...es-times-by-business-hours.20261/#post-123412

Regards,

 

[edved81]

Resolved!

Thanks!