sumings cells which contain hr:min:sec

A

Anthony

am trying to autosum a column the cells of which contain time, eg 01:12:55
however it nevers seems to calculate the correct answer.
any ideas would be grate!
 
N

Niek Otten

Format the result as [h]:mm:ss

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
A

Anthony

that worked!
thanks!

Niek Otten said:
Format the result as [h]:mm:ss

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

Anthony said:
am trying to autosum a column the cells of which contain time, eg 01:12:55
however it nevers seems to calculate the correct answer.
any ideas would be grate!
Click to expand...
Click to expand...
 
Top