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]) )

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

Thank you so much for your help, 

 

if i want to calculate the average of this colonne after using this formula : TotalSecond column = HOUR([Time])*3600+MINUTE([Time])*60+SECOND ([Time]) 

 

is it gona be: 

 

Average in seconds = Average ([Time])????

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
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]) )