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

Thanks

Need Help
  • harryli's avatar
    harryli
    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.

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    3 years ago

    Use this in a custom column

    = DateTime.ToText(DateTime.From(Text.Middle([#"current - consult"],2)),"mm")
    • harryli's avatar
      harryli
      Helper II
      3 years ago

      this method only available to "Import" mode

  • harryli's avatar
    harryli
    Helper II
    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.