Hi All
Hope you are well. I need some help on my formala or method.
I am calculating how long it took for a unique reg for a unique day and driver to the the movement.
I tired the formula below but didnt work. The coloumn in Red is what I need.
Is there a solution to this. I have attached the sheet
thanks
5 answers
Hi A.J.,
If you could try adding this calc to the sheet:
IF [Time] = {FIXED [First Name], [Regn] : MAX([Time])} AND {FIXED [First Name], [Regn] : COUNTD([Time])} > 1 THEN
{FIXED [First Name], [Regn] : MAX([Time]) - MIN([Time])}
ELSE NULL
END
Also, you may need to format the field using hh:mm:ss format. Let me know how that works!
