calculate on time

[sallyt]

I want to deduct one time from another and then use the
resultant cell to then calculate a cost. Eg time 09:00
and 11:00 deduct one from other and get 02:00 However. I
want to use that 2 to represent 2 hours and multiply by a
cost eg £10 per hour. Cannot do this if I use the =TEXT
function to deduct one time from another or even if I just
use minus. What do I need to do to then calculate on the
result? Thanks very much. Sall

 

[Harald Staff]

Hi Sall

02:00 is NOT 2
02:00 is 2/24

So multiply 02:00 with 24 and then with cost for the desired result.

HTH. Best wishes Harald

"sallyt" <[email protected]> skrev i melding
I want to deduct one time from another and then use the
resultant cell to then calculate a cost. Eg time 09:00
and 11:00 deduct one from other and get 02:00 However. I
want to use that 2 to represent 2 hours and multiply by a
cost eg £10 per hour. Cannot do this if I use the =TEXT
function to deduct one time from another or even if I just
use minus. What do I need to do to then calculate on the
result? Thanks very much. Sall

 

[Andy Brown]

A1 = 09:00
B1 = 11:00
C1 = £10.00

D1 formula ; =((B1-A1)*24)*C1

Rgds,
Andy

 

[Guest]

Many thanks!! Sorry to be so dim .....


Sall