Even hours are easily displayed by simply adding a space after the number:
2 p
4 a
12 p
The cells must be formatted as General or Time before the entry.
A number format will have to be multiplied by 24 to display time.
As far as the colon is concerned, if you're entering a large amount of time
data, for say timecards, you could *temporarily* use "AutoCorrect", and have
that feature change a decimal point (period) input to the colon for easy,
fast time entry, and then delete the change when you're done entering the
data.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
I figured that out,( =int )was the key, but here is another one,
How can I format the input cells to accept times in the format 2p to mean
2:00pm?
And if I could use 230p to mean 2:30 pm that would be cool but I don't
believe that I can could on that. I am just trying to make the data entry
easier. Having to convert to 24 hour time etc. A list box perhaps...
