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 mahoneypat This is what i get: Might be the reason that Im using charlie eidens duration and displaying time as a whole number.
Anonymous
My formula is based on Time data type column, if you have any other type, I need to do it differently.
You may share a sample PBIX file to check.
________________________
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 mahoneypat You will find my pbix file here: https://gofile.io/d/Vsei2l The column name is NewTIme
Anonymous
I modified the formula, you can try now:Rounded Time = VAR T = TIME(0,0,[Time]) RETURN IF( MINUTE(T) >= 40, MROUND(T, 1/24 ), HOUR(T)/24 )If you want to extract the hour as a number then apply the below formula and format it as the Whole Number
Rounded Time = VAR T = TIME(0,0,[Time]) RETURN HOUR( IF( MINUTE(T) >= 40, MROUND(T, 1/24 ), HOUR(T)/24 ) )________________________
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.