Forum Discussion
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...
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.
Use this in a custom column
= DateTime.ToText(DateTime.From(Text.Middle([#"current - consult"],2)),"mm")this method only available to "Import" mode