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