Forum Discussion
Rounding up time
Hey guys, I've got the following situation below and basically in the column where the time is, I need to round it up to only hours, if its above 40 minutes. So lets say its 15:30 then it displays 15...
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 🙂
Please try a column expression like this to get your desired result.
Rounded Time = var hours = HOUR('Table'[Time])
var minutes = MINUTE('Table'[Time])
return IF(minutes>=40, hours +1, hours)
Regards,
Pat