Calulating hours, minutes and seconds

L

Linda Le Geyt

I have an excel spreadsheet which could contain hundreds of rows with hours,
minutes and seconds. I need to calculate into hours, minutes seconds the
total duration. I have completed a SUM and changed the calculation total to
HH:MM:SS to stop the 24 hour roll up, however, my total only shows 00:00:00.

Any suggestions?? Thanks

Below is a shortened example ex
01:04:07
00:00:27
00:10:39
00:00:28
00:07:59
00:00:01
00:01:18
00:28:33
 
S

Stefi

Let Excel make an Autosum and it will sum up your data and format the result
Sum cell like [h]:mm:ss and show the result of 1:53:32

Regards,
Stefi

„Linda Le Geyt†ezt írta:
 
L

Linda Le Geyt

Thanks for the info, however, clicking the autosum (and adding the column
rows) still does not calculate the total, just shows 00:00:00
--
Linda Le geyt


Stefi said:
Let Excel make an Autosum and it will sum up your data and format the result
Sum cell like [h]:mm:ss and show the result of 1:53:32

Regards,
Stefi

„Linda Le Geyt†ezt írta:
I have an excel spreadsheet which could contain hundreds of rows with hours,
minutes and seconds. I need to calculate into hours, minutes seconds the
total duration. I have completed a SUM and changed the calculation total to
HH:MM:SS to stop the 24 hour roll up, however, my total only shows 00:00:00.

Any suggestions?? Thanks

Below is a shortened example ex
01:04:07
00:00:27
00:10:39
00:00:28
00:07:59
00:00:01
00:01:18
00:28:33
 
S

Stefi

Please post the cell format codes and the SUM function!
Stefi


„Linda Le Geyt†ezt írta:
Thanks for the info, however, clicking the autosum (and adding the column
rows) still does not calculate the total, just shows 00:00:00
--
Linda Le geyt


Stefi said:
Let Excel make an Autosum and it will sum up your data and format the result
Sum cell like [h]:mm:ss and show the result of 1:53:32

Regards,
Stefi

„Linda Le Geyt†ezt írta:
I have an excel spreadsheet which could contain hundreds of rows with hours,
minutes and seconds. I need to calculate into hours, minutes seconds the
total duration. I have completed a SUM and changed the calculation total to
HH:MM:SS to stop the 24 hour roll up, however, my total only shows 00:00:00.

Any suggestions?? Thanks

Below is a shortened example ex
01:04:07
00:00:27
00:10:39
00:00:28
00:07:59
00:00:01
00:01:18
00:28:33
 
D

David Biddulph

Are you sure your input cells aren't text strings, rather than times?
--
David Biddulph

Linda Le Geyt said:
Thanks for the info, however, clicking the autosum (and adding the column
rows) still does not calculate the total, just shows 00:00:00
--
Linda Le geyt


Stefi said:
Let Excel make an Autosum and it will sum up your data and format the
result
Sum cell like [h]:mm:ss and show the result of 1:53:32

Regards,
Stefi

"Linda Le Geyt" ezt írta:
I have an excel spreadsheet which could contain hundreds of rows with
hours,
minutes and seconds. I need to calculate into hours, minutes seconds
the
total duration. I have completed a SUM and changed the calculation
total to
HH:MM:SS to stop the 24 hour roll up, however, my total only shows
00:00:00.

Any suggestions?? Thanks

Below is a shortened example ex
01:04:07
00:00:27
00:10:39
00:00:28
00:07:59
00:00:01
00:01:18
00:28:33
 
B

Bob Phillips

The format of the total should be [h][:mm:ss.

Are you sure the data is not text cells, but are real time?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Stefi said:
Please post the cell format codes and the SUM function!
Stefi


"Linda Le Geyt" ezt írta:
Thanks for the info, however, clicking the autosum (and adding the column
rows) still does not calculate the total, just shows 00:00:00
--
Linda Le geyt


Stefi said:
Let Excel make an Autosum and it will sum up your data and format the result
Sum cell like [h]:mm:ss and show the result of 1:53:32

Regards,
Stefi

"Linda Le Geyt" ezt írta:

I have an excel spreadsheet which could contain hundreds of rows with hours,
minutes and seconds. I need to calculate into hours, minutes seconds the
total duration. I have completed a SUM and changed the calculation total to
HH:MM:SS to stop the 24 hour roll up, however, my total only shows 00:00:00.

Any suggestions?? Thanks

Below is a shortened example ex
01:04:07
00:00:27
00:10:39
00:00:28
00:07:59
00:00:01
00:01:18
00:28:33
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top