Help with Time, and Alert Formula

Registration date
Thursday November 14, 2013
Last seen
November 14, 2013
- Nov 14, 2013 at 02:31 PM
 RickQAS - Jan 6, 2014 at 12:33 AM
Hey all..
New to the forum, so please be gentle.. hehe

I working in a busy office/communications orientated job, and I am wanting some help with a formula, if possible, that looks at the current real time, and if the current time equals the time in a particular cell, a pop-up Reminder Alert comes up (and flashes maybe)..

EG: If I put into cell B3 the time of 08:45, at the exact real time of 08:45 an Alert Pops up..

Or Again, If I put into cell B3 the time of 08:45, at 1 minute before the real time of 08:45 an Alert Pops up..

The input time into a cell will be changed daily, depending on different shifts, and different required reminders, so the formula does need to be flexible...

Oh I am also new to Macro's etc, so if you can guide me through that it would be greatly appreciated... Thx

Hope this all makes sense, and thank you so much in advance..

Cheers Rick..

2 replies

Registration date
Thursday January 28, 2010
Last seen
May 5, 2022
Nov 15, 2013 at 06:29 PM
What you seek seems to be doable. One point you need to keep in mind is how many cells it needs to check and how frequently. Here is a similair issue, see if you it gives you some help
Had a go... And cant seem to get it to work??

As I'm new with Excel, I dont know exactly how to write all the formula's etc..

Some assistance would be greatly appreciated..

Thanks in Advance.. :-)