Forum Discussion

rco123456's avatar
rco123456
Microsoft Employee
5 years ago
Solved

duration to minuets

i'm trying to convert a duration value to decimal number 

i want to get the value as minutes 

when i'm doing this on the power query i'm getting a very smalll number 

 

the duration values that i had are in column sessiontime-copy 

 i'm getting after the convert  the coulmn sessiontime

 

 how can i do it?

  • I think you want 

    Duration.TotalMinutes([theDurationColumn])

     

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion

    I think you want 

    Duration.TotalMinutes([theDurationColumn])