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

Calculate After hours 3
How do I calculate total pay from pay rate times hours and minutes 4
years-months-days-hours 8
Calculate Hours 1
Calculating occupational sick pay entitlement 0
How do I get total amount of hours in time format 3
Auto calculating time 1
Time calculations for Scheduled vs Actual Employee Time and Wages 5

Top