Hi @Anonymous
Are you able to clarify what "replace 'ThisItem.Time' with the name of the value that contains the time column):" actually means? i assume "value" is incorrect and it needs the variable or data card?
I have 2 DC's and have tried updating the ThisItem.Time to the DC eg openFromDC.Time.
What this means is that it's necessary to replace ThisItem.Time with a reference to the field that contains your time data. So in the case of where you want to display OPEN_FROM, the formula you would use is this:
Time(
If(
IsBlank(Find("H", ThisItem.OPEN_FROM)), // Check if there is an hour component
0, // If not, the value is zero
Value( // Otherwise, take the substring between 'PT' and 'H'
Mid(
ThisItem.OPEN_FROM,
3,
Find("H", ThisItem.OPEN_FROM) - 3))),
If(
IsBlank(Find("M", ThisItem.OPEN_FROM)), // Check if there is a minute component
0, // If not, the value is zero
Value( // Otherwise take the substring between the rest of the value
Mid( // after the hour component and the 'M' indicator
ThisItem.OPEN_FROM,
If(
IsBlank(Find("H", ThisItem.OPEN_FROM)),
3,
Find("H", ThisItem.OPEN_FROM) + 1),
Find("M", ThisItem.OPEN_FROM) -
If(
IsBlank(Find("H", ThisItem.OPEN_FROM)),
3,
Find("H", ThisItem.OPEN_FROM) + 1)))),
If(
IsBlank(Find("S", ThisItem.OPEN_FROM)), // Check if there is a second component
0, // If not, the value is zero
Value( // Otherwise take the substring after the minute or hour indicator,
Substitute( // remove the 'S' indicator, then take the value
Mid(
ThisItem.OPEN_FROM,
If(
!IsBlank(Find("M", ThisItem.OPEN_FROM)),
Find("M", ThisItem.OPEN_FROM) + 1,
!IsBlank(Find("H", ThisItem.OPEN_FROM)),
Find("H", ThisItem.OPEN_FROM) + 1,
3)),
"S",
""))))
And in the case of OPEN_TO, you would replace ThisItem.OPEN_FROM with ThisItem.OPEN_TO.
