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]

[Dan Mezick]

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.

Thanks for the reply. Yeah, knew about the column width. Only recently figured out the start/stop thingie.

Appreciate your input.