View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frederick Chow Frederick Chow is offline
external usenet poster
 
Posts: 75
Default 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?