summing of time

[Andrew@rushington]

i have a range of cells in a column formatted as hh:mm:ss that i need to
total to give total hh:mm:ss, when i do it gets to 24 then starts again is
there another solution?

 

[Stefi]

Format Sum cell like this: [h]:mm:ss

Regards,
Stefi


„Andrew@rushington†ezt írta:

 

[Andrew@rushington]

thanks that did it

Format Sum cell like this: [h]:mm:ss

Regards,
Stefi


„Andrew@rushington†ezt írta:

i have a range of cells in a column formatted as hh:mm:ss that i need to
total to give total hh:mm:ss, when i do it gets to 24 then starts again is
there another solution?

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„Andrew@rushington†ezt írta:

thanks that did it

Format Sum cell like this: [h]:mm:ss

Regards,
Stefi


„Andrew@rushington†ezt írta:

i have a range of cells in a column formatted as hh:mm:ss that i need to
total to give total hh:mm:ss, when i do it gets to 24 then starts again is
there another solution?