Results 1 to 10 of 10

Thread: Warning Alerts Depending On Time Remaining To Finish Task

Threaded View

peter renton Warning Alerts Depending On... 06-12-2013, 05:31 PM
peter renton Hi Has anybody any... 06-16-2013, 06:42 PM
Excel Fox Change your formula as... 06-16-2013, 07:34 PM
peter renton Hi Thanks for looking at... 06-16-2013, 09:00 PM
Excel Fox Except for the warning at 1... 06-17-2013, 09:22 AM
peter renton Hi Sorry still cant seem... 06-17-2013, 12:36 PM
peter renton hI I have added the coding ... 06-18-2013, 07:23 PM
peter renton Hi I have manged to sort... 06-18-2013, 08:13 PM
Excel Fox Working on this. Will send... 06-18-2013, 11:56 PM
peter renton Thank you for looking at it%D... 06-19-2013, 12:20 PM
Previous Post Previous Post   Next Post Next Post
  1. #1
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    13

    Warning Alerts Depending On Time Remaining To Finish Task

    Hi
    I have attched a workbook,

    When the time required for is entered in column J column k counts down the time left to complet the job, the cell goes red with one
    hour to go.

    is it possible to do the following:-

    When the half hour left is reached a warning alert message box and or audio alert is shown, but if the completed box is selected in column P the alerts are disabled and the time frozen in K ???

    Regards


    Peter
    Attached Files Attached Files

Similar Threads

  1. Replies: 6
    Last Post: 06-06-2013, 03:17 AM
  2. Calculate Time Difference Between Time In HH:MM
    By Stalker in forum Excel Help
    Replies: 8
    Last Post: 03-28-2013, 03:27 PM
  3. Displayin Date/Time in "original" time zone
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-21-2012, 02:02 AM
  4. Replies: 2
    Last Post: 12-12-2011, 01:51 PM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM

Posting Permissions

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