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

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

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

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

"Nikki27" wrote:

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

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

Thank you :-)

"pdberger" wrote:

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

"Nikki27" wrote:

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