Forum Discussion
Differense between 2 dates and time
Ive got a table with columns like this. 1 column, persons (ID) 1 column with date and time (shiftstart) 1 column with date and time (shiftto) And i want to see how many rows that have less the...
Idrissshatila
Super User
Super User
try this
Hours = Datediff ( ShiftFrom, ShiftTo, Hour )
Just put the field shift from and shift to in the measure.
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
I tried it but it only counts the hours between shiftstart and shiftto on one line.
I want to know the hours between date 1 and date 2.
If there is less then 11 hours between ShiftTo date 1 and ShiftStart date 2.