time formatting

daveyc18

Active Member
Joined
Feb 11, 2013
Messages
440
when i enter this "=TEXT(NOW(),"hh:mm")"

i get military format....i want 13:30 displaysed as 1:30 pm instead

i tried chagning the formatting via ctrl + 1, but to no avail
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
Change the formula to =NOW() and format as you like.
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,746
Office Version
2010
Platform
Windows
=MOD(NOW(), 1)) and format as you like.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,030
Messages
5,466,120
Members
406,468
Latest member
Toto Li

This Week's Hot Topics

Top