Hi people,
I need to find a way to translate every 20 minutes to a unit.
In example:
20 minutes ==> 1
40 minutes ==> 2
60 minutes ==> 3
80 minutes ==> 4
100 minutes ==> 5
dim Date1 as date, dim Date2 as date
'Date1 and Date2 are always multiples of 20 minutes so I try:
Dif=(Date1-Date2)/0.333???
Could anybody help?
Thanks,
Aldo.
Bookmarks