I am trying to calculate the amount of time elapsed between two logged events. Column D has the person's ID and column O has the elapsed time. The raw data has multiple ID's but everything is in time numerical order.
I am trying to get Excel to subtract two time stamps in column O based on the ID in column D. My formula is =SUM(O102-O101). This is assuming that line 101 and 102 is the same ID. It could be o154-o101. I have tried several ways of embedding this in if functions but can't seem to get it to recognize the string correctly or perform the sum function.
Bookmarks