| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
24 Hour Format For Timesheet
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! -- faisca_aem ------------------------------------------------------------------------ faisca_aem's Profile: http://www.excelforum.com/member.php...o&userid=16098 View this thread: http://www.excelforum.com/showthread...hreadid=556293 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
24 Hour Format For Timesheet
Hi!
Use this format: [hh]:mm The [ ]'s keep the hours from rolling over. Biff "faisca_aem" wrote in message ... 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! -- faisca_aem ------------------------------------------------------------------------ faisca_aem's Profile: http://www.excelforum.com/member.php...o&userid=16098 View this thread: http://www.excelforum.com/showthread...hreadid=556293 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
24 Hour Format For Timesheet
Biff, you're a genius!!! Thanks! :D -- faisca_aem ------------------------------------------------------------------------ faisca_aem's Profile: http://www.excelforum.com/member.php...o&userid=16098 View this thread: http://www.excelforum.com/showthread...hreadid=556293 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
24 Hour Format For Timesheet
You're welcome!
Biff "faisca_aem" wrote in message ... Biff, you're a genius!!! Thanks! :D -- faisca_aem ------------------------------------------------------------------------ faisca_aem's Profile: http://www.excelforum.com/member.php...o&userid=16098 View this thread: http://www.excelforum.com/showthread...hreadid=556293 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Format Cell | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
