Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I use excel spreadsheet for entering my time worked. I have it currently set
to add up hours worked, etc. Is there a formula I can enter to have excel convert from time format to tenths. For example, if I work 8 hours and 12 minutes, I want it to convert it to 8.2 hours. We use the conversion chart below. Any suggestions? 1-6 minutes = .1 7-12 minutes = .2 13-18 = .3 19-24 = .4 25-30 = .5 31-36 = .6 37-42 = .7 43-48 = .8 49-54 = .9 55-60 = 1.0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting time to decimal | Excel Worksheet Functions | |||
converting a decimal to time | Excel Worksheet Functions | |||
Converting decimal to time | Excel Discussion (Misc queries) | |||
Converting Decimal to Time | Excel Discussion (Misc queries) | |||
Converting from time format to decimal and figuring the difference | Excel Discussion (Misc queries) |