elapsed time formula for open office calc
I'm trying to set up a timesheet in an OO spreadsheet. I enter starting
time in c1 and ending time in c2 (formated as 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. I suppose I could jury-rig a formula, but is there an easier way to do this? |
Just starting to use OO myself, but I can talk about what to do in Excel - probably the same:
The cell with the =c2-c1 will adopt the number format of c1&c2, i.e. the time format. Change to number format for the cell containing =c2-c1 to be a general number and not a time format. Hope that works with OO! |
All times are GMT -5. The time now is 08:48 AM. |