Solved How to calculate business days, hours and minutes?

mayraguilar 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 •

mmcconaghy 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 •

Start a discussion

Related Solutions

› [Solved] How to calculate working days and hours?
› [Solved] How to get the total hours an emplyee worked for the week.
› [Solved] How to calculate no of days between two dates in Ms.Excel ?.
› how to calculate age in Access 2007?
› [Solved] Excel 2013 - How to calculate date based on day of week
› [Solved] Need EXCEL formula to find an average of days hours minutes
› [Solved] Business day+ hours calculation

See More ↓

Ask Your Question

Weekly Poll

Do you think Intel's new hybrid chips will better compete with Apple/ARM?

Poll Finishes In 5 Days.
Discuss in The Lounge
Poll History