| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting Time to units | Excel Worksheet Functions | |||
| Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
| elapsed time displayed as a decimal | Excel Worksheet Functions | |||
| Keep number format after converting time to text | Excel Discussion (Misc queries) | |||
| Time - converting HH:MM:SS to Minutes | Excel Worksheet Functions | |||
Threaded Mode
