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]

Re: Spreadsheet Question - how to total a Time column
 

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

Re: Spreadsheet Question - how to total a Time column
 

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 ###.

Re: Spreadsheet Question - how to total a Time column
 

[ 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.

Re: Spreadsheet Question - how to total a Time column
 

[ 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

Re: Spreadsheet Question - how to total a Time column
 

[ 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.

Re: Spreadsheet Question - how to total a Time column
 

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

Re: Spreadsheet Question - how to total a Time column
 

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

Re: Spreadsheet Question - how to total a Time column
 

[ QUOTE ]
Try changing the format of the cells.

[/ QUOTE ]


ka-ching! problem go bye-bye.

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

Re: Spreadsheet Question - how to total a Time column
 

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

Re: Spreadsheet Question - how to total a Time column
 

Thanks for that. MS's site is so friggin' big I get lost trying to find something there. This pinpoints me now.

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

Re: Spreadsheet Question - how to total a Time column
 

Express tim as fractions of an hour (N.NN)

(Stop-start)/60 = time expressed in hours.

10:15 stop, 9:30 start = 45/60 = .75 (do this by hand at the end of the session)

Put the resulting .75 in the column for elapsed time.

Then use SUM() to get your total SUM() hours. I use this method for summing time.

By the way if you get "#####" for the result try widening the column. The #### usually means not enough width available to express the full value. Your result may have many decimal places that is causing this effect.

Re: Spreadsheet Question - how to total a Time column
 

Thanks for the reply. Yeah, knew about the column width. Only recently figured out the start/stop thingie.

Appreciate your input.