Forum Discussion
Rounding up time
Anonymous
You need to use the seconds as input for my formula, it converts it into time.
I have attached your file with the column added.You can download the file: HERE
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy This does make sense, however, I need the column to be in the whole number format rather than time.
This is the code I use for my time.
Trukmė Prastova Radviliškis Convert = VAR Duration = SUM ( 'Avg By Day'[avg_time] ) // There are 3,600 seconds in an hour VAR Hours = INT ( 'Avg By Day'[avg_time] / 3600 ) // There are 60 seconds in a minute VAR Minutes = INT ( MOD ( 'Avg By Day'[avg_time] - ( Hours * 3600 ), 3600 ) / 60 ) VAR Seconds = ROUNDUP ( MOD ( MOD ( 'Avg By Day'[avg_time] - ( Hours * 3600 ), 3600 ), 60 ), 0 ) RETURN Hours * 100 + Minutes