Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Evaluate Time

  1. #1
    New Member
    Join Date
    Oct 2016
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Evaluate Time


    Evaluate Time
    Hi,


    I am trying to evaluate a time value in a query with a calculated column. I have 2 columns; Login Polling Interval and Logout Polling Interval. If the record is considered logged in at 0600 then I want a 1 in the column. If the record is considered logged out at 0600 then I want a 0 in the column. The Login and Logout values are in 24 hour clock and can span days. So for example the first record logged in at 20:18 and stayed logged in until 06:45 the next morning. So in this record the 0600 column should have a 1 because it was logged in at 0600.


    I don't care about the spanning of days, I'm just looking for an evaluation of the 0600 time block. This is what my formula currently is but it is not working:


    0600 = IF([LOGIN_TIME]=BLANK(),BLANK(),IF([Login Polling Interval]<=TIMEVALUE("06:00")&&[Logout Polling Interval]>=TIMEVALUE("06:00"),1,0))



  2. #2
    New Member
    Join Date
    Sep 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Evaluate Time

    Let me understand it first if the duration between logged in and logged out passes 6 in the morning than you want 1 otherwise you want a zero

  3. #3
    New Member
    Join Date
    Oct 2016
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Evaluate Time

    Yes correct

  4. #4
    New Member
    Join Date
    Sep 2018
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Evaluate Time

    Give me the file and Ill see what I can do

Some videos you may like

User Tag List

Tags for this Thread

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
  •