Get the certain index value

[harryli]

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

[harryli · Accepted solution]

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.

[Vijay_A_Verma]

Use this in a custom column

= DateTime.ToText(DateTime.From(Text.Middle([#"current - consult"],2)),"mm")

[harryli]

this method only available to "Import" mode