| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
in excel totaling weekly hours military time
I really need help. I've been ask to create a time sheet that auto
calculates time both daily total and weekly toals. once my sheet goes past 24 hours the totals are not correct. I've tried changing to absoultes, tried changing from military time to text, nothing works. Thank you all, mel |
|
#2
|
|||
|
|||
|
Mel,
Just format the totals cell as [hh]:mm, this will overcome the resetting trait. -- HTH RP (remove nothere from the email address if mailing direct) "mel" wrote in message ... I really need help. I've been ask to create a time sheet that auto calculates time both daily total and weekly toals. once my sheet goes past 24 hours the totals are not correct. I've tried changing to absoultes, tried changing from military time to text, nothing works. Thank you all, mel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| How do I convert Military Time to minutes? | Excel Worksheet Functions | |||
| How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2. | Excel Discussion (Misc queries) | |||
| Adding time in Excel | Excel Worksheet Functions | |||
Linear Mode
