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