Filter problem
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Filter problem

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

    Default

     
    I used the formulae
    =B3+(1-B2)
    where b3 and b2 are times.However the resultant stored data cannot be filtered for time greather than 2:00. even when the format is set to time.

  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

      
    Can you give a detailed description of what you would like to see on your screen.

    It would help if you gave an example with no.s and what the desired result would be.

    ps reply to this post instead of creating a new topic. Its alot easier to see what was commented on before.

    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