Search for last date and first date and subtract to get hours
I have a large data set with multiple occurrences of a value of 505, I need to find the time the value 505 occurred and subtract the dates to get the total time the value 505 occurred.
I also need to do a similar subtraction to get the hours the column labeled PV was equal to or greater than 490, sometimes that occurs one value below the last occurrence of 505 in the SP column. Please see the attached workbook hopefully it will be more clear, the value in green is the dates I would need to subtract to get the hours the system was greater than or equal to 490. I have over 31,000 lines to get through so any help to automate this would be appreciated.
My spreadsheet also shows some formulas I have tried but with no luck.
Thank you,
dan
|