Hello I'm trying to figure out the time difference between data in Column K and J. I need to know how long it took for data to be updated by the amount of days it took, hours, or minutes and am using those columns. I also want to get the average amount of time only if the names in Column A match and enter that information in Column N. This is what I have so far for the first part.
Thanks for the help.ActiveSheet.Name = "Raw Data"Range("M2:M").Value = ("K2:K-J2:J" > 1) + ("d:hh:mm")
Reply With Quote
