| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Cells to calculate hours and minutes taken to complete task | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| How to calculate hours? | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| calculate hours | Excel Discussion (Misc queries) | |||
Hybrid Mode
