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.
|
Results 1 to 4 of 4
Thread: Excel 2000 - time functionThreaded View
|
Click Here to Expand Forum to Full Width |