Shouldn't it just know that's what I'm doing?

Well, they tried to program it to be "helpful" but it hasn't worked out so
good!

You're welcome!

--
Biff
Microsoft Excel MVP


"Cheryl" wrote in message
...
Whoops! Well, dang. Shouldn't it just know that's what I'm doing?
(JK!!)

Thanks!

"T. Valko" wrote:

If I enter the hours in this template using am/pm
time this is what I get:
C3 D3 E3 F3 Total
8:00 11:00 12:00 3:00 -6.00

Ok, but you *didn't* enter the time a AM/PM. You *have to include (type
in)
the AM/PM*. If you don't then the entry defaults to AM. So, 3:00 is being
evaluated as 3:00 AM.