Results 1 to 13 of 13

Conditional Formula for time window to include a buffer zone

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Conditional Formula for time window to include a buffer zone

    I am trying to update this formula in column 'J' to account for a buffer time or 5 mins (more of less) i.e so if the arrival time is 5 mins late or early it will still account for the 'On time' status.


    I keep getting an error when I use 'AND"
    is there a proper way to account for this. I need this only in column "J" so it will still work even If I dont have column K
    Last edited by sonny.thind; 08-23-2011 at 11:46 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

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