Changing Decimal to Hours

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Charlene - 12 Apr 2006 14:58 GMT

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 to this Message

Sloth - 12 Apr 2006 15:15 GMT

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.

> An employee is purchasing vacation per pay. My spreadsheet works like
> this.
[quoted text clipped - 14 lines]
>
> How do I convert the 12.73 to read 13.13

Reply to this Message

bpeltzer - 12 Apr 2006 15:19 GMT

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.

> An employee is purchasing vacation per pay. My spreadsheet works like
> this.
[quoted text clipped - 14 lines]
>
> How do I convert the 12.73 to read 13.13

Reply to this Message