It's bad enough that people work through midnight and you have to modify
formulas because people just record the time and not the date, but now you want
Excel to figure out if you mean AM or PM -- I certainly would not want to touch that.

Data Validation would not require another column. See
http://www.contextures.com/tiptech.html

And I think you meant 0:00 (midnight) instead of 1:00 and you are confusing
the heck out me, and proably anyone who would use or update your worksheet.
More information on Date and TIme
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/datetime.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"gjcase" wrote in message
...

I have a spreadsheet with time entries on it. Problem is any entries
after 1:00 are assumed by Excel (2002) to be AM. Does anyone know how
to reset the assumption? I'd like the AM/PM assumption to switch at
6:00 vs 1:00.

I know we can just enter 1:00 as 13:00 or as 1 p, but I'd prefer to not
rely on the data entry to get that right.

I know I can use data validation to flag the entry, but again, I'm
looking for the least intrusive method. I would also prefer that we not
have to enter data in one column & process it in another. Any ideas?

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=528671