Forum Discussion

mbrierley's avatar
mbrierley
Icon for Advocate II rankAdvocate II
6 years ago

Average time appears as text

We report on average working time and each month a report is generated from our finance team that is sent to me. This provides an average number of hours individuals have worked in a 17 week period. ...
Need Help
AZJohnPowerBI's avatar
AZJohnPowerBI
Icon for Helper I rankHelper I
4 years ago

If you're presenting Average Times in Days:Hours:Minutes:Seconds try the following:
Convert your excel chart to seconds (Usually =cell*86400)
Then make a new column in Power BI with the following

'Title of your column' =
//Days
Right("0"&INT('FACT Table Name'[Column Name]/86400),2)&":"
//Hours
&Right("0"&INT('FACT Table Name'[Column Name]/3600),2)&":"
//Minutes
&Right("0"&INT(('FACT Table Name'[Column Name]-INT('FACT Table Name'[Column Name]/3600)*3600)/60),2)&":"
//Seconds
&Right("0"&MOD('FACT Table Name'[Column Name],3600),2)