Forum Discussion
Solved
Calculation of TIME
Hello all, Quite new to BI. I have a table containing a column of the 'Training time' of several tasks, and another column containing its respective 'Admin time'. The format of both column ...
AntBI26 , Consider changing the data types of the 'Training Time' and 'Admin Time' columns (or duplicates of those) to Decimal in Power Query. 'Total Time' can then be added as a new column by adding the first two.
You may also want to refer the solution given in this post:
Solved: Problems with hours greater than 24 hours - Microsoft Fabric Community
Cheers,
Amol
AntBI26 , Consider changing the data types of the 'Training Time' and 'Admin Time' columns (or duplicates of those) to Decimal in Power Query. 'Total Time' can then be added as a new column by adding the first two.
You may also want to refer the solution given in this post:
Solved: Problems with hours greater than 24 hours - Microsoft Fabric Community
Cheers,
Amol
