entering time - excel does not show seconds

[lezawang]

Hi
I entered time like this 1:30:44 am but excel only shows 1:30 am. Why is that and how can I fix that? thank you so much.

 

[mrshl9898]

1:30 AM is hh:mm AM/PM. You'll need to format as hh:mm:ss AM/PM.

You can format the cells, it's in the custom menu. Or format the cells with a formula =TEXT(A1,"h:mm:ss AM/PM")

 

[Scott Huish]

You just need to change how it's formatted.

Select your cells.
Hit CTRL-1
On the number tab, click on Custom
Under the box that says Type:
put this
h:mm:ss am/pm
Click OK.