Time in excel

  • Thread starter Thread starter hpman247
  • Start date Start date
H

hpman247

Ihave another ? about time.

I would like to multiply how much someone make in an hour by how many
hours they have worked. I cant figure out how to do this without
manually entering the numbers i need in the right place. I need some
kind of formula to calculate this please.

Thanks
 
Start time in A1
End Time in B1
Rate per hour in C1

in D1

=MOD(B1-A1,1)*24*C1

Format the cell as General or number or currency (it will probably default
to time).

Time is stored as a fraction of a 24 hour day, so you need to multiply by 24
to get hours.
 
Back
Top