View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Cheryl Cheryl is offline
external usenet poster
 
Posts: 144
Default Time sheet template military hours problem

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.