Add times, convert to number not time of day?
 

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

Add times, convert to number not time of day?
 

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 ???

Add times, convert to number not time of day?
 

=MOD(B1-A1,1)

format as hh:mm or [h]:mm

--


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

Add times, convert to number not time of day?
 

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

Add times, convert to number not time of day?
 

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