thank you very much :-D
just what I needed!

"Peo Sjoblom" wrote:

Oops! Make that

=MOD(B1-A1,1)*24


format as general or number

--


Regards,


Peo Sjoblom

"spezticle" wrote in message
...
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