Re: summing h:mm column for timecard sheet ?
- From: David Stanaway <david stanaway net>
- To: Sven Crouse <svenc snet net>
- Cc: gnumeric-list gnome org
- Subject: Re: summing h:mm column for timecard sheet ?
- Date: Wed, 20 Jul 2005 23:15:36 -0500
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]