Forum Discussion

harryli's avatar
harryli
Helper II
3 years ago
Solved

Get the certain index value

Dear all, as you may see in the above picture of column[current - consult]. I would like to make a column the value will be like the following: New current - consult 22 32 null 15 39 T...
  • harryli's avatar
    3 years ago

    I make the new column be like:

    ((Time.Hour(DateTime.LocalNow()) - Time.Hour([CONSULT_TIME]))*60)
    +((Time.Minute(DateTime.LocalNow()) - Time.Minute([CONSULT_TIME])))

    to solve my problem, thanks all.