In the document attached, you can see a list of tourism cards usage for a city.
For example, card number 240250 is a 24hours card and has been used during 1 day only, first time at 13:21 and second time at 15:34 during the 22nd of the month.
What I need to do is to see whether this 24h card, is used during 1 day only (like in my example card id 240250) or over 2 days, like the card number 2402518
I do no know what would be the best representation for that kind of information ??, knowing that I need to do this exercice for also 48h and 72h cards ?