if then statements

[Guest]

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?

 

[Bob Phillips]

do you mean

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

--

HTH

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

 

[Earl Kiosterud]

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.

 

[Guest]

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]

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)