Hello there, thank you for looking at my question.
An example of the data that I have is as follows:
The logic for my formula is as follows:
If the unitcode equals GMTST1 and the descript equals "Dispatched", then subtract the any other unitcode's "Arrived" timestamp, from the GMST1 "Dispatched" timestamp.
Basically, GMST1 is the baseline for when a unit is technically dispatched (not the Dispatched time next to GMAT18 or GMAT1 for example). I'm trying to find the time it takes from GMST1 dispatch, to each individual unit's arrival time.
So if GMAT1 and GMAT 18 were dispatched for the same event, both of their individual response times should be represented by subtracting GMTST1's dispatched time, from their own arrival time.
I tried using a datediff formula, but kept getting errors, or incorrect numbers. Thank you so much for your time and assistance!
(As a side note, these are all grouped by event numbers, and each group is separated by a line)
IP Logged
