Excel 2000 - time function

[Rashid Khan]

I have a worksheet designed as follows:
Column A has the beginning time (say 1:00)
Column B has the stop time (say 2:00)
Column C has the elapsed time (=b1-a1)which in this case is 1:00
My problems is that I want to use the result in Column C to be multiplied (say Rs. 2 per minute). Now when I try to do this it gives me fancy results.
Anybody can help me in this matter
Thanks

[Edited by Rashid Khan on 03-30-2000 at 11:57 AM]

[Lyla]

Hi.

Generaly it would be:
=((B1-A1)*60)* 2

But, what is the format of C ? HH:MM ??
Also, what is the value of the rate(2)?
If 2 Cents then:
=((B1-A1)*60)* 0.2

Good luck.

[Rashid Khan]

[QUOTE][B]
I have a worksheet designed as follows:
Column A has the beginning time (say 1:00)
Column B has the stop time (say 2:00)
Column C has the elapsed time (=b1-a1)which in this case is 1:00
Column D has the formula =c1*2
My problems is that I want to use the result in Column C to be multiplied (say Rs. 2 per minute). Now when I try to do this it gives me fancy results.
Anybody can help me in this matter
Thanks

[

[Edited by Rashid Khan on 04-01-2000 at 01:28 PM]

[Lyla]

Rashid,

1- Format A abd B columns:
Format cell -> Time -> chose 13:30
then press CTRL+Shift+; for current time

2- format C column:
Format cell -> Custom -> [m]
Formula =B2-B1 to have total # of Minutes Only.
If you want the result only:
Formula =(B2-B1)*2 ' But You wouldn't be able to format the result as currency !

3- format D column:
Format cell -> Custom -> [m]
Formula: C1*2

If that's Not what you are looking for, clearfiy ?