Working Days, Hours and Minutes Formula
I've used this site for Excel help for years and thanks to all the knowledgable members who give up their time to help others I have learned so much so I thought it's about time I joined and tried to give something back to others.
I'm also joining with a question.
This thread here: http://www.ozgrid.com/forum/showthread.php?t=87732 titled "Work Days And Hours Between Two Dates & Times" almost answers my query and it was a valuable read, however I am still having a bit of an issue.
As the thread title suggests I am looking to get the number of working days, hours and minutes between two set dates.
Example: (Sunday) 05/08/2012 11:00 to (Monday) 06/08/2012 09:30 should show as "0 day(s) 0 hour(s) and 30 minute(s)" but in my sheet it shows as "00 day(s) 08 hour(s) 00 minute(s)" for some weird reason.
I have uploaded my file to show you what I am trying to work with. Thanks in advance!
If you have any questions please let me know.
Video Tutorials / Excel Dashboards Reports