How to use time data values in expression

[Olivier Makart]

Hello

 

I intend to make an average of data during a specific duration.

My current formula is this one:

If([Time] in (Low, High),Avg([Lower Probe]) OVER ([iD]),null)

I need to replace Low and High by appropriate time value.

But when entering data from my data columns, it gives an error message.

What is the appropriate way of formating data in this expression (see attached for time format in my data file)

 

Thanks

Best regards

Olivier

[Olivier Makart]

Hello

 

I have partially answerd my question:

The following formula now gives me a blank answer. instead of error So I understand I need to use coma for time serapators.

If([Time] in (Time(12,00,0,0), Time(12,40,0,0)),Avg([Lower Probe]) OVER ([iD]),null)

Although, as mentioned the answer is blank. How to translate "12:00:00 AM" into the time expression above