Thanks I wasn't putting in the space

"venkat" wrote:


from the top of the head should there not be a spca betwen time and am or pm
even if you type 5:00 a it will be eneterd as 5:00 AM and the formula bar
will show 5:00:00 AM
if you dont give space it will be taken as text.
i hope I am correct.

"Oldjay" wrote:

I have a time sheet that calculates time worked. I have the input cells for
the time in, lunch out, etc. They are all formatted Time - 1:30PM. 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?

oldjay