LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LostNFound
 
Posts: n/a
Default If Functions for Lates

I want the formula to look in column A and if there is a 1 and column C is
greater than 15 minutes above column B I want it to return a "yes".. But if
Column A is not a 1 then I want to use 30 minutes as the standard. and
perform the same function. If the time in C is less than the 30 or 15 minutes
then I want it to return a "No"

I am trying to track the delivery times wether they were Late or Not and the
first stop we have a fifteen minute window while all others are 30 minutes
and early is not a problem.

Thanks To all who can contribute
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Perform functions on the result of adding two columns Tim Archer Excel Worksheet Functions 2 February 2nd 05 03:25 PM
# of Functions per cell SUB-ZERO Excel Worksheet Functions 3 January 23rd 05 10:35 PM
PivotTable canned functions doco Excel Discussion (Misc queries) 0 January 14th 05 03:52 PM
How to load Engineering Functions into the Fx function wizard? jsaval Excel Worksheet Functions 1 November 11th 04 09:47 PM
Where can I see VBA code for financial functions? eios Excel Worksheet Functions 1 November 2nd 04 01:00 PM


All times are GMT +1. The time now is 08:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"