When entering time, I type simply the 8 and the colon and press enter, and
it's in there as 8am. I do have to enter afternoon times militarily though,
as in 13 colon 30 for 1:30pm, but it saves a lot of entry time.

"Oldjay" wrote...
The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the
calculations are correct. How do I format the cells so that I don't have
to enter the seconds? <<