|
#1
|
|||
|
|||
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] |
#2
|
|||
|
|||
Re: Spreadsheet Question - how to total a Time column
It's not that your column is too narrow, is it?
-Sam |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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 ###.
|
#5
|
|||
|
|||
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
|
#6
|
|||
|
|||
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] |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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] |
#9
|
|||
|
|||
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>format cells>time> 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. |
#10
|
|||
|
|||
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 |
|
|