| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
add time above 24 hours
I'm trying to add my colums to equal a total amount of time but it just says
00:00? I formatted the cell to show hh:mm:ss then did a =sum(....) is this right? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
add time above 24 hours
Hi Keith,
Try to format your cell containing the SUM formula as "[h]:mm:ss" instead. Frederick Chow "KeithM" wrote in message ... I'm trying to add my colums to equal a total amount of time but it just says 00:00? I formatted the cell to show hh:mm:ss then did a =sum(....) is this right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add 10,0015:15 hours to 03:53 Hours to a total time | Excel Worksheet Functions | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| Converting Millitary Time to Hours worked and OT hours | Excel Worksheet Functions | |||
| How do add time/hours to get answer in hours if Ans24 | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
Linear Mode
