Spreadsheet Question - how to total a Time column

I've got a column of hours and minutes (00:00) I'm trying to total. Each cell is the result of a start and end time that works fine.

What I can't get is a result once the total exceeds 24 hrs. I've tried -
<ul type="square"> =SUM(C.1:C50)[/list]and get "#####" as a result.

I checked the first few cells (less than 24 hrs total) and it works.

Any suggestions? Thanks.

[img]/images/graemlins/confused.gif[/img]

[SamIAm]

It's not that your column is too narrow, is it?
-Sam

[CrashPat]

Try changing the format of the cells. I use openoffice, not excel so it might be different but if I change from the default formatting to [HH]:MM:SS it works. The brackets around the HH allow it to go past 24 hours, if I leave those off it cycles on the 24 hour clock, so 23:45 + 1:15 results in 01:00 instead of 25:00. You also need to make sure that the column is wide enough to display the result or it will be ###.

[Timer]

[ QUOTE ]
I've got a column of hours and minutes (00:00) I'm trying to total. Each cell is the result of a start and end time that works fine.

What I can't get is a result once the total exceeds 24 hrs. I've tried -
<ul type="square"> =SUM(C.1:C50)[/list]and get "#####" as a result.

I checked the first few cells (less than 24 hrs total) and it works.

Any suggestions? Thanks.

[img]/images/graemlins/confused.gif[/img]

[/ QUOTE ]

Make sure the format is :

right click the cell&gt;format cells&gt;time&gt; then select (on office 2000 sixth one down or 37:30:55

Try this first, if that doesn't work, I'll try something else.

[SamIAm]

[ QUOTE ]
Try this first, if that doesn't work, I'll try something else.

[/ QUOTE ]I'm going to add this to the bottom of all my posts.
-Sam

[ QUOTE ]
It's not that your column is too narrow, is it?
-Sam

[/ QUOTE ]

That was my immediate first thought, but no, column width didn't correct it.

Thank you. This might be the answer. I'll try it and let you know. Again, muchos gracias. And I'm using OpenOffice 2.0

Big thanks to you, too. That's another possibility.

[ QUOTE ]
Try changing the format of the cells.

[/ QUOTE ]


ka-ching! problem go bye-bye.

[img]/images/graemlins/smile.gif[/img]

[Timer]

If you have further problems with Excel, including complicated formula questions you can go to this newsgroup and get good answers quickly:

microsoft.public.excel.misc