MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to calculate total man hours in excel


Posted by Albert Corbin on December 31, 2001 9:09 AM

I am to total the man hour in excel. But, it keep going back to 0:00 after 24 hours. Please advise of the correct formula


Posted by IML on December 31, 2001 9:14 AM

Change to custom format of [h]:mm (nt)