PDA

View Full Version : Day/Time difference VBA



Pancakes1032
04-04-2015, 03:51 PM
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.


ActiveSheet.Name = "Raw Data"Range("M2:M").Value = ("K2:K-J2:J" > 1) + ("d:hh:mm")

Thanks for the help.

skywriter
04-04-2015, 06:55 PM
Cross posted on Oz Grid.