Forum Discussion

pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper V
5 years ago

TimeBetween function or similar?

So, I'm familiar with the DatesBetween function. I need similar results but, using Time.   For example, we have a use case wherein we have hours worked data for each hour of the day:   Start 2:00...
Help
pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper V
5 years ago

Thank you so much for taking the time to reply.

 

Could you please elaborate a bit more on how this concept can calculate sum of hours between two time periods (regardless of date, we are always only looking at today).

 

thank you again

  • Radhika2605's avatar
    Radhika2605
    Icon for Helper II rankHelper II
    5 years ago

    Hi pawlowski6132 

     

    The expression in the filter context is checking for each row all the dates which are less than or equal to the time in the current context. Say we are at 4pm right now - so the filter will check the time in the first row time (2pm) and compare it with 4 pm as it is less then it will take this. then it will move to the second row and compare the time and keep on adding the values...

     

    Side note - If you have both am as well as pm values then I would suggest using 24 hr time period instead of 12 hr for easier calculation.

     

    Hope this clarifies.

     

    Thanks

    Radhika