Forum Discussion

ayoubb's avatar
ayoubb
Icon for Helper IV rankHelper IV
6 years ago
Solved

converting hour format to seconds

plz could you help me to convert this: 00:06:30 to seconds in power bi Thank you
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi ayoubb 

    for average with v-alq-msft solution you can try AVERAGE([TotalSecond column])

    or

    AVERAGEX(Table, HOUR([Time])*3600+MINUTE([Time])*60+SECOND([Time]) )