if then statements
 

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?

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?

Rudy,

Be aware that the formula solution Bob suggested will always be the current
date or tomorrow's date from the current date. That means if the sheet is
opened a week later, it will change to the current date (that the sheet was
opened). If you wanted a permanent date, it will require a macro.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Bob Phillips" wrote in message
...
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?

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?

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?