Evaluate Time

[amulder]

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))

 

[IbrahimAnjum]

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

 

[amulder]

Yes correct

 

[IbrahimAnjum]

Give me the file and Ill see what I can do