formula for returning am or pm from a time

[steddas]

i have a spread sheet with time in cell a4, the following formula returns whether it is AM or PM

=IF(A4<0.5,"AM","PM")

but i want the cell to remain blank if nothing is entered in cell a4

i have tried
=IF(A4,(A4<0.5,"AM","PM"),"with no success

any ideas ?????

[mrice]

Try

=IF(A4<>"",IF(A4<0.5,"AM","PM"),"")

[steddas]

Thank you that worked a treat your a star

[daddylonglegs]

You can also use TEXT function here, e.g.

=TEXT(A4,"AM/PM;;")

[steddas]

Thanks Daddylonglegs just tried that and it works you have both made it look easy i was tearing my hair out any help is much appreciated thank you