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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Decimal to Hours
12.73 hours does NOT equal 13 hours and 13 minutes. It equals 12 hours and
44 minutes. That being said; if you want to convert decimal hours to excel time, then divide that number by 24. You will need to change the format to something like this... [h]:mm hope this helps. "Charlene" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Decimal to Hours
Why are you interpreting the 12.73 as 12 hours and 73 minutes? 280 dollars
divided by 22 dollars per hour is 12.73 hours, where the 0.73 is 73 hundredths of an hour, NOT 73 minutes. If you want to express 12.73 hours as hours:minutes, divide by 24 then format the result as time. "Charlene" wrote: 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 |
Reply |
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) |