Not getting Duration to work.

[filip_u_s]

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 I wonder why... and what I can do about it!

[Greg_Deckler · Accepted solution]

@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 · Accepted solution]

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.

[filip_u_s]

wow, thanks collinsg... that really did the trick and so easily!

[Greg_Deckler · Accepted solution]

@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.

[filip_u_s]

Thank you Greg... you were so right... shame there is no time.totalminutes... but now I can keep building my report 🙂