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 > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
