How can I calculate hours into pay...in this format hh:mm:ss

N

Nikki27

If the total hours worked is 7 hours and 30 minutes and is displayed as
07:30:00
how do can I then calculate this for pay.

I am using example as £10 perhour. I thought you would use =A1*10 and this
would multiply the hours worked by the amount earned per hour. However, it
does not work with the time in this format.
How do I convert the hh:mm:ss to show something like 7:5 or 7.30, which
would then allow me to multply ??

Many Thanks
 
P

pdberger

The thing to remember is that Excel tracks time as a portion of a day. You
see 12:00pm, but the real number it's using is 0.5 -- half the day is gone.

One way of doing this is:

A B C
1 7:30 $10 =A1*B1*24

computes to $75.

HTH
 
N

Nikki27

Thank you :)

pdberger said:
The thing to remember is that Excel tracks time as a portion of a day. You
see 12:00pm, but the real number it's using is 0.5 -- half the day is gone.

One way of doing this is:

A B C
1 7:30 $10 =A1*B1*24

computes to $75.

HTH
Click to expand...
 

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

How do I calculate total pay from pay rate times hours and minutes 4
Calculate Hours 1
years-months-days-hours 5
Calculating Working Hours, Days and Overtimes. 1
Calculating numbers of hours worked in pay divisions 1
How do I calculate time in excel (clock in and clock out 3
How do I format a cell to calculate overnight Hours? 7
Time calculations for Scheduled vs Actual Employee Time and Wages 4

Top