[KLUG Members] elapsed time calculation

[Eric Beversluis]

On Tue, 2005-03-29 at 11:57 -0500, Jamie McCarthy wrote:
> econophil at charter.net (Eric Beversluis) writes:
> 
> > 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?
> 
> Not sure if this is what you need, but I see =c2-c1 (where c2 and c1
> are both formatted with the Time format code "HH:MM:SS", if it
> matters) as returning a fractional value of the number of days
> difference.  I have to format the formula's cell into the Number
> category, of course.  Then =(c2-c1)*86400 gives me the number of
> seconds between the two times, =(c2-c1)*24 the number of hours, etc.

That seems to work. Thanks.
EB