| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I summarize time that exceeds 24 hours?
I am working on a diving log book and need to accumulate the total bottom
time. Example: Accumulated bottom time from earlier dives 95:16, Time of this dive 00:40. Total acc time 95:56. How do I fill in the time 95:16? What cell format do I use? How do I summarize 95:16 with 00:40 and get 95:56? What function / cell format? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I summarize time that exceeds 24 hours?
Rose, format the cells as custom [h]:mm then just add the cells together
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rose" wrote in message ... I am working on a diving log book and need to accumulate the total bottom time. Example: Accumulated bottom time from earlier dives 95:16, Time of this dive 00:40. Total acc time 95:56. How do I fill in the time 95:16? What cell format do I use? How do I summarize 95:16 with 00:40 and get 95:56? What function / cell format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a decimal time into hours and minutes | Excel Worksheet Functions | |||
| Performing Math with Time over 24 hours | Excel Worksheet Functions | |||
| Time sheets | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Hybrid Mode
