[KLUG Members] elapsed time calculation

Eric Beversluis econophil at charter.net
Tue Mar 29 08:33:49 EST 2005


I'm trying to set up a timesheet in an OO spreadsheet. I enter starting
time in c1 and ending time in c2 (formated at time of day). When I enter
the formula  =c2-c1 I don't get elapsed time but a different time of the
day.  I don't find any formula in the OO help that gives elapsed time in
hours and minutes. How would one do this?

Eric



More information about the Members mailing list