| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Function
Is there anyway to change the format in the function NOW() so the time is NOT
military time? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Function
The now function just returns the time. The formatting of the result is based
on the cell formatting. Right click the cell and select Cell Format. Select time and choose the one you want... -- HTH... Jim Thomlinson "Té" wrote: Is there anyway to change the format in the function NOW() so the time is NOT military time? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Function
Thank You!
"Jim Thomlinson" wrote: The now function just returns the time. The formatting of the result is based on the cell formatting. Right click the cell and select Cell Format. Select time and choose the one you want... -- HTH... Jim Thomlinson "Té" wrote: Is there anyway to change the format in the function NOW() so the time is NOT military time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time function | Excel Worksheet Functions | |||
| verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
| Time VBA or NOW function | Excel Discussion (Misc queries) | |||
| One-time NOW() function | Excel Worksheet Functions | |||
| Function to convert Time String to Time | Excel Worksheet Functions | |||
Linear Mode
