newparadigmz
asked on
Excel formula or function to count time differences
I have a cell on a sheet with a formula that displays a time, and through an RTD mechanism in the background, it updates that time.
I need a way to get the difference in time between each update, and record how many times that difference went over a certain threshold, say 5 minutes.
I need a way to get the difference in time between each update, and record how many times that difference went over a certain threshold, say 5 minutes.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks!
Is it working?
Will you please provide a sample data where RTD is recorded? or Please provide Column name? also from to which row?
Anyway, I have attached a sample workbook and tweaked a bit. Change the details and see, if it helps you.
Recording-events-triggered-by-RTD-d.xlsm