# =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

1. ## =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

=IF(F5<(F5+TIME(F5+2, 0, 0)),"GOOD","CANCEL")

I'm attempting to input a time in F5(would be the current time Shift+CTRL+. I want for cell G5 to let me know when the original time is 2 hours past cell F5.

What am I doing wrong? I've attached the Excel sheet that I'm working on. Ideally what I'm looking to do is once it gives me a positive("GOOD") I want to set up an auto email sent to my outlook. Anyone that can help please and thank you.

2. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

Not sure I fully understand but that formula will always be true while ever the time function is positive, ie 1 will always be less than 1 + a positive number. Are you trying to use actual time? Try now() instead

3. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

"want for cell G5 to let me know when the original time is 2 hours past cell F5"
Can you Brief this part again
Punnam

4. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

OK. G5 is in the area of your table where it is 4 hours but try this in C3 and copy down and for G3 down chnage the 2 to 4

``Please Login or Register  to view this content.``

5. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

No that didn't work Crooza. That just made 11am-11pm GOOD and the others cancel.

Ugh I'm not sure why this is so difficult. I've been messing with functions for the last two days and no luck.

6. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

If you want to test for time relative to "now", you need to use the NOW() function. Remember though, that will include the date, so if you are comparing to just time, you will need to strip the date part out...use =MOD(A1,1)

Also, for TIME to update, the workbook needs to have a change made (F2, calc, enter something etc)

7. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

Try this...
=if(MOD(NOW(),1)+"2:00"<=your cell time+"2:00",GOOD","CANCEL")

8. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

Originally Posted by FDibbins
Try this...
=if(MOD(NOW(),1)+"2:00"<=your cell time+"2:00",GOOD","CANCEL")
That worked FDibbins but had to remove the +"2:00" from the part after <=. Now the you said that it something has to update on the report for the NOW function to work. Is there a way for it to Auto update something on the report. My plan is for once something reads as "CANCEL" I want to my a function for that to send an email to myself to pretty much tell me to stop slacking and get it canceled.

=IF(MOD(NOW(),1)+"2:00"<=B4,"GOOD","CANCEL")

9. ## Re: =if(f5<(f5+time(f5+2, 0, 0)),"good","cancel")

The +"2:00" is what adds the extra 2 hours, and no, there is no way (apart from using VBA) to automate the update

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1