User Profile
alexnattrass
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Re: Elapsed time IF condition is met
NikolinoDE Thanks again... I'm still struggling to get any output. I have changed the VBA to reflect the name of the table (Foss_List), however nothing is showing in the 'Duration Operational' column, despite there being a 'Status' as "Operational". Excel version - Office 16 file type .xlsm storage medium - one drive OS - Windows 10 EnterpriseRe: Elapsed time IF condition is met
NikolinoDE Thanks very much for your response. I am having a few issues getting it to work. Can you check I have input correct? Also, I'd like to fill this down the column of a table (where column S has the name "Duration Operational", and column I = "Status"). Can this be written in so that the formula works down all rows? Also, column I will change its string based on an IF formula. I'm assuming this timer will be able to record the change in the cell, even if data isn't manually input? Thanks again for your help, it's much appreciated!Elapsed time IF condition is met
Hi there, Is it possible to record elapsed time IF a condition is met? For example, I'd like to record the amount of time that cell I4 (Status) contains the string "Operational". This Status is likely to change regularly, but would need the elapsed time recording from the previous value. Almost like a stopwatch starting and stopping, but not re-setting. Please advise Regards
