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 🙂
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 🙂
Or if i extract just the hour, I get zeros:
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 Ive got it working now, however one of the drive time was 24:52 and when it rounds up it produces 1.