Time formats

  • Thread starter Thread starter Tracey
  • Start date Start date
T

Tracey

I am creating a template which requires the user enter a time (not
present time, flight times), for example the user will be listing a
number of flight arrivals and departures and what I want to do is have
the user simply enter something like 804p and have the cell display it
as 8:04 pm. I have looked at some custom formats and nothing seems to
be able to do this. Any help would be appreciated.
Thanks!
Tracey
 
Back
Top