Custom Column

[bdehning]

I have a Custom Column with the following:

24 Hour =Time.From( Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24 )

I need to add code to account for time that is 11:30 PM and later as it creates an error as it can not do 24:00.

Also I want to add,  if null then No Entry.  

Can I do that in Custom or can I convert Custom to Conditional Column?

[amitchandak]

@bdehning , If data type is time, Then 24 hours display is just a display property

or you can try like

Time(hour([Time]), Minute([Time]), 0)

If this does not help
Can you share sample data and sample output in table format?

[bdehning]

Using 24 Hour Claims =Time.From( Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24 )

I get the following,  How do I account for the error because of the time that is 11:46:00?

 

[v-zhangti]

Hi, @bdehning 

You can try the following methods.

Time.From(if Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24=1 then 0.5 else Number.Round( Number.From( [Time of Incident] ) * 24 ) / 24)

Is this the result you expect?

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.

[bdehning]

It's really close.  How do I get any time with :30 to round up to the next hour?   

It currently rounds down

[v-zhangti]

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.

[bdehning · Accepted solution]

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.