| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Decimal to Hours
An employee is purchasing vacation per pay. My spreadsheet works like
this. Week 1 Withheld $39.00 Week 2 Withheld $39.00 Week 3 Withheld $39.00 Week 4 Withheld $39.00 Week 5 Withheld $39.00 Week 6 Withheld $39.00 Week 6 Withheld $46.14 Total Withholdings $280.14 Divided by Hourly Rate $ 22.00 Time Purchased 12.73 Hours (which would be 13 hours and 13 minutes) I am taking 60 minutes from the .73 and adding 1 hour to the 12, making it 13 hours. The remaining .13 minutes is the difference between .73 less .60 How do I convert the 12.73 to read 13.13 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Hours to Decimal | Excel Worksheet Functions | |||
| adding rows of hours and minutes to get a total | Excel Worksheet Functions | |||
| Changing default decimal places | Excel Discussion (Misc queries) | |||
| Changing display of decimal value based on the value in the cell | Excel Worksheet Functions | |||
| Format a cell to display decimal hours. | Excel Discussion (Misc queries) | |||
Threaded Mode
