Time Function

  • Thread starter Thread starter Té
  • Start date Start date
T

Té

Is there anyway to change the format in the function NOW() so the time is NOT
military time?
 
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...
 
Thank You!

Jim Thomlinson said:
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...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting Standard Time to Military Time in Excel 2
Military time 4
Excel time conversion issue 4
formula help 3
How to customize =Now() 11
Chinese + Russian miitary to replace Microsoft products. 2
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
Time Conversion in Spreadsheet 6

Back
Top