Time Format

[mikeymay]

I have a number of cells displaying times in 'hh:mm:ss' and I want to total the sum of all the cells.

When I use the SUM function, the result, if left in the format 'hh:mm:ss' and is over over 23:59:59 returns the number of hours in excess to full days (24 hours) so 13:31:12 + 13:31:12 = 3:02:24 and not 27:02:24.

Is there a way of changing the format to do this?


Thanks

 

[DonkeyOte]

change format of cell to: [h]:mm:ss

 

[VoG]

Use a custom format

[h]:mm:ss

 

[mikeymay]

Blimey....that was quick!!!

Thanks guys