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