Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
Show and Tell
  • Fowmy's avatar
    Fowmy
    5 years ago

    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 🙂

    YouTube  LinkedIn

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fowmy  Yes that does make sense, however I would need to display 25, as in my vizualisations im displaying hours, any way to adjust the code?

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

Try this formula.

Column = 
VAR x = FORMAT( [Trukmė Prastova Radviliškis Convert], "00:00")
VAR __right = RIGHT(x, 2)
VAR __left = LEFT(x, 2)
RETURN
IF(
    __right >= "40",
    __left+ 1,
    __left-0
)

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.