Try it for yourself and see the result!
column a = 9:00am column b = 9:30am column c = (b-a) column d = rate $1.05)
column = solution (should be $31.50)

"Peo Sjoblom" wrote:

=(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?