| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format question
Whenever I use this formula to show days, it returns a string of decimal
places like 3.66666666 days. I would like for it to show something like 3 days 6 hours. Here is the formula I'm using =SUM(G:G)/L1&"Days" Thanks in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format Question | Excel Discussion (Misc queries) | |||
| Format % Question | Excel Worksheet Functions | |||
| Format Question | Excel Worksheet Functions | |||
| Format question | Excel Discussion (Misc queries) | |||
| Format Question Please | Excel Discussion (Misc queries) | |||
Threaded Mode
