ExcelBanter - summing of time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - summing of time (https://www.excelbanter.com/excel-worksheet-functions/167940-summing-time.html)

Andrew@rushington[_2_]

summing of time

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

summing of time

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?

Andrew@rushington[_2_]

summing of time

thanks that did it

"Stefi" wrote:

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

summing of time

You are welcome! Thanks for the feedback!
Stefi

€žAndrew@rushington€ ezt Ã*rta:

thanks that did it

"Stefi" wrote:

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?

All times are GMT +1. The time now is 02:32 AM.