Well, here's the deal. This is an employee schedule. I'm trying to make it
easy for managers to input. Everything is ok until someone works the night
shift into the next day because when I try to subtract 11pm from 7am the
answer is wrong. I'd like to make it so that the managers don't have to type
the date for every in and out entry. I can make it so that the today's date
falls in automatically, but for the night shift people there has needs to be
two dates. I want them to be able to enter only in and out times and the
thing calculate number of hours worked even if it's from 11pm to 7am the next
day. By the way, thanks tons for the help.

Rudy

"Bob Phillips" wrote:

do you mean

=IF(A1<0.5, Today(),Today()+1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Atlanta Rudy" wrote in message
...
Help!

If cell A1 has an AM time entered (e.g. 7:00am), then cell B1 = the next
date (e.g. 1/6/05). Is this possible?