#11
|
|||
|
|||
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] |
#12
|
|||
|
|||
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. |
#13
|
|||
|
|||
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. |
|
|