Forum Discussion
Custom Column
That was close.
I had to use
Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24=1 then 0.0 else Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24)
This allowed time under :30 to go back to the hour.
It's really close. How do I get any time with :30 to round up to the next hour?
It currently rounds down
Hi, bdehning
You can try changing Number.Round to Number.RoundUp.
Time.From(if Number.RoundUp( Number.From( [Time of Incident] ) * 24 ) / 24=1 then 0.5 else Number.RoundUp( Number.From( [Time of Incident] ) * 24 ) / 24)
Does this meet your desired outcome?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That was close.
I had to use
Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24=1 then 0.0 else Number.Round( Number.From( [Time of Incident] ) * 24.01 ) / 24)
This allowed time under :30 to go back to the hour.