Check if current time then calculate else display previous calculated value no change

[SachinPA]

Hi ,

I am trying to calculate running values for time based intervals

My table is as follows

Time Value

09:00 AM 100
09:15 AM 120

If current time is 09:00 AM It will calculate value from source data and display the value. For 09:15 AM no values will be calculated

If Current time is 09:15 AM then it will not do anything on 100 at 09:00 AM Value but calculate new values from source data for 09:15 AM.

Is it possible ?

I tried to do it but once current timestamp condition is satisfied lets say 09:15 AM then previous values go away for 09:00 AM.

 

[SachinPA]

Sample Data for reference

Interval ->	0:15
Start Time	End Time	Check	Result
1:23 PM	1:38 PM	TRUE	Y
1:38 PM	1:53 PM	FALSE	FALSE
	Check formula	AND(TIME(HOUR(NOW()),MINUTE(NOW()),0)>=TIME(HOUR(A3),MINUTE(A3),0),TIME(HOUR(NOW()),MINUTE(NOW()),0)<TIME(HOUR(B3),MINUTE(B3),0))
	Result Formula	if(C3=true,"Y")