Filter problems
Filter problems
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Filter problems

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Want to filter a series of times eliminating the times less than 02:00. I did this using custom filter, and it work when i calculate the times one way and does not work when i calculate the times another. I require the time to be calculated the second way.the two formulas are "B3-B2",and the 2nd one is b3+ (23:59 - B2).Where b3and b2 are times.

  2. #2
    Board Regular George J's Avatar
    Join Date
    Feb 2002
    Location
    Edinburgh, Bonnie Scotland
    Posts
    951
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Not sure if this is what you are looking for.

    =B3+(1-B2)

    This is B3(say 07:00)
    + 1 day - B2(say 03:00)
    This gives 28hrs

    Can you give more details if you are looking for something different?


    George J

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com