=(B1-A1)*24*rate

format for number or currency

Regards,

Peo Sjoblom

"Keith" wrote:

please be more specific as to how to do this. Thanks, Keith

"Peo Sjoblom" wrote:

=total_time*24*rate formatted as number or currency


Regards,

Peo Sjoblom

"Keith" wrote:

If in column A I have the time a job started and in column B the time a job
ended and I find the time elapsed in column C. From column D I have entered
a fixed rate. I want excel to calculate the amount due in column E. How do
I do this?