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.