I have the below table with Order Created time and Order End time which are at a difference of 1 hour. I would like to create a timer in a new column for each row which starts automatically when QV file is opened until
Basically, the timer should consider current time now(), compare it to the Order End time, and if it is less than it, it should give a result countdown of 'Order End time - now()' automatically on opening. If it is not less, it should say 'Time is Up'.
Please help me create this timer in a straight table.
Now() function is dynamic and would change with every passing minute... I think this should give you what you want... the only thing to be concerned about is the performance because of Now() which essentially updates every second...
It gives me TIME IS UP for all the rows even though that's not true.
And I am looking for a clock countdown like in the attachment. Please take a look.
For CURRENT SYSTEM TIME Column: [Interval([ORDER END TIME] - Now(), 'hh:mm’)
For TIMER Column: Interval([ORDER END TIME] - Now(), 'hh:mm’) & ‘ ‘ & if(Sign( Interval([ORDER END TIME] - Now(), 'hh:mm')) = '-1', ‘LEFT’ ,’UP’)
Note: make the Now() function with the same format of CURRENT SYSTEM TIME