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?

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?