Hi,
I need to have a solution to evaluate "Date" and "Card number" then return min and max of "Hour" of a specific card in a specific day.
for example min hour of 1122 in 1 jun 2019 is 5:20 and max is 12:00.
(the result could be in any format (table, Pivot, new column or ...)
dataset is attached and is something like this:
card number.jpg
Many thanks in advance
Bookmarks