Printable View
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]
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.
[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]
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 ?