View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charlene
 
Posts: n/a
Default Converting decimal to time

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)

How do I convert the 12.73 to read 13.13