Entering times (2000/SP3)

Topic

New Reply

Your code contains

If Application.Intersect(Target, Range(“B6:C31”)) Is Nothing Then

so it only checks cells in the range B6:C31, and ignores all others, such as B32!

Reply | Quote

Replies

Thank you Hans. I am a little embarrassed because I had forgotten that I even HAD code in the workbook!

Thanks again…

Reply | Quote

If you hadn’t had code, 1130 would never be changed to 11:30 AM.

Reply | Quote

Typo in subject corrected by HansV to aid future searches

Help. I have a spreadsheet that is confusing me. The sheet is used to track accumulated time during a visit. In the attachment, look at cells B31 and B32. I normally enter the time in 24 hour format (ie: 1100, 1400, etc). Every thing is fine until I get to cell B32. when I enter 1100 or 1400 I get 12::00 AM.

Note that I use the same format in cell B31 and it works as it should!

As far as I can tell, the cells are formatted identically.

Any Ideas??

Reply | Quote