| 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 |
| 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) | |||
Threaded Mode
