Forum Discussion

filip_u_s's avatar
filip_u_s
Regular Visitor
2 years ago
Solved

Not getting Duration to work.

Hi all. I'm trying to get out the total number of minutes from "Sluttid" and "Starttid" and find how many minutes differs the two. However Durations don't seem to work like you can see below and ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    filip_u_s I think your two columns are Time columns and not Duration columns so you will need to convert them to Duration columns first. Or use Time.Minute instead.

  • collinsg's avatar
    collinsg
    2 years ago

    Good day filip_u_s,

    Table.AddColumn(#"Filtrerade rader1", "Mintid", each Duration.TotalMinutes([Sluttid]-[Starttid]), Int64.Type)

     gives,

    This should work provided Sluttid is greater than Starttid.

    Hope this helps.

collinsg's avatar
collinsg
Solution Sage
2 years ago

Good day filip_u_s,

Table.AddColumn(#"Filtrerade rader1", "Mintid", each Duration.TotalMinutes([Sluttid]-[Starttid]), Int64.Type)

 gives,

This should work provided Sluttid is greater than Starttid.

Hope this helps.