24 Hour Format For Timesheet

F

faisca_aem

I'm working on a personal timesheet. Time In and Time Out are in 12 hr
format. Then I total Daily, Weekly, and Monthly figures. However, if
my total exceeds 24 hrs then it wraps over (ie - 25 hrs 15 mins becomes
1:15). I'm currently using the "hh:mm" format for totals, but have
tried others with no success.

I would like the values to be in hours and minutes. When the minutes
exceed 60, I would like it to add 1 to hours and reset minutes to 00.
Does this make sense? If so, is it easy to fix?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How many are at work every hour in a 24-hour day? 2
Timesheet - convert time format 4
How do I sum times to get a total hour value? If I add up to 24 h. 2
formula or calculation for adding negative hour and positive hours 1
Entering times in 24 hour format 12
How do I convert time to the nearest 1/4 hour with a 7 min. window 4
Excel Timesheet Error 2
advice on rounding or ceilng a 24 hour time value 3

Top