Add times, convert to number not time of day?

  • Thread starter Thread starter spezticle
  • Start date Start date
S

spezticle

Okay, this should be pretty simple.

17:24:00 + 00:24:00 = 7

5:00 PM + 9:30 PM = 4.5

That's what i'm trying to achieve.
A start time, a finish time, and the time it took between them.
Not a clock time of 5pm + 9pm = 2am

How can this be done?
thanks,

Benjamin
 
i forgot, i might want to add this in.

I did this:
a1 - 9:30
a2 - 10:00
a3 = a2-a1
the result is .02 ???
 
Oops! Make that

=MOD(B1-A1,1)*24


format as general or number

--


Regards,


Peo Sjoblom
 
Back
Top