time formatting

[daveyc18]

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

 

[shg]

Change the formula to =NOW() and format as you like.

 

[daveyc18]

Change the formula to =NOW() and format as you like.

the formula is as such to exclude the date

 

[shg]

=MOD(NOW(), 1)) and format as you like.