Solved How to calculate business days, hours and minutes?

October 12, 2015 at 07:34:09
Specs: Excel
I have two time stamps (shown below) and I would like to calculate business day, hours, and minutes between the two that is only exclude the weekends. I would also like to display it in the following format DD:HH:MM. Thank you in advance for you help.

Start
10/7/2015 10:11 AM

End
10/7/2015 11:33 AM

This is currently in the format MM/DD/YYYY H:MM AM/PM


See More: How to calculate business days, hours and minutes?

Report •


#1
October 12, 2015 at 09:00:57
✔ Best Answer
Look at this thread and see if it works for you

http://www.computing.net/answers/of...

Any questions or problems just ask.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question