| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting decimals to Time
My data for work time is
1.1 1.017 etc... I need to convert this to 1:06 1:01 etc.. and have this data be used in a Pivot Table that shows the average time of all of these cells. When I convert using =TEXT(A1/24,"h:mm"), I get #DIV/0 in the Pivot Table. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Time from Hours and Minutes Decimals in a formula | Excel Discussion (Misc queries) | |||
| Converting Time to decimals and then converting decimals to time | Excel Worksheet Functions | |||
| converting time to decimals | Excel Worksheet Functions | |||
| converting decimals to fractions | Excel Discussion (Misc queries) | |||
| Converting decimals into hh:mm | Excel Worksheet Functions | |||
Threaded Mode
