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

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

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

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? <<