A1 contains 11:00PM, B1 contains 7:00AM, C1:=MOD(B1-A1,1), correct answer?

--

HTH

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


"Atlanta Rudy" wrote in message
...
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?