Spreadsheet Question - how to total a Time column

CrashPat · #1 12-15-2005, 02:29 PM

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

#2 12-15-2005, 03:31 PM

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

#3 12-15-2005, 06:07 PM

[ QUOTE ]
Try changing the format of the cells.

[/ QUOTE ]

ka-ching! problem go bye-bye.

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

Timer · #4 12-15-2005, 09:26 PM

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

#5 12-15-2005, 10:31 PM

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]