Good afternoon,
I have spent the better part of this afternoon searching this forum and internet to try and solve a problem I am having with a time sheet in excel. I'm hoping someone can see what I can't.
I've attached a test time sheet for reference.
Basically this time sheet calculates hours work daily and then calculates a weekly total. The person inputs that time in this format: HH:MM AM/PM.
The daily and weekly totals are in his format: H:MM (military time).
Then at the bottom of the spreadsheet I'm trying to calculate the cumulative totals from the weeks. Right now the issue I'm having is after 24 hours or above. Like in the test spreadsheet the true total I want to be 25 not 1:00. How do I convert the cumulative total to a number? I've tried formatting the cell, but I'm not getting the right results.
Any ideas?
Bookmarks