Re: summing h:mm column for timecard sheet ?



Do you want the total hours formatted h:mm ?  If not, you can change the
format of the sum cell to number and multiply it by 24 to get hours.
Alternately, change the format to [h]:mm .

On Wed, 2005-07-20 at 22:49 -0400, Sven Crouse wrote:
I have two columns formatted as h:mm representing start and stop times
for work.  I can subtract the start time from the stop time for hours
worked that day, but when I sum a column of "hours worked that day" and
that value > 24 then I increment the day.  Is there a way to get total
hours for a h:mm formatted column ?

Sven
_______________________________________________
gnumeric-list mailing list
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list





[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]