ExcelBanter - Time Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Time Function (https://www.excelbanter.com/excel-discussion-misc-queries/194208-time-function.html)

Té

Time Function

Is there anyway to change the format in the function NOW() so the time is NOT
military time?

Jim Thomlinson

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?

Té

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?

All times are GMT +1. The time now is 03:08 AM.