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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate times between dates and times in Excel 1
Determine if night shift by start & end time 2
Time calculations for Scheduled Time vs. Actual Time Worked 1
Auto calculating time 1
sick time usage 4
Convert Time to Number 1
time v cost calculation in Excel 2002 (XP) 4
Multiplying the number in one cell and providing the product in an 4

Back
Top