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

Fowmy's avatar
Fowmy
Super User
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 Ive got it working now, however one of the drive time was 24:52 and when it rounds up it produces 1.

 

 

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Anonymous 

     

    That is correct,  24 is midnight, 24:57 is next day 1am when rounded up. 

    hope this clarifies 

     

    ________________________

    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.