Convert a whole number to an hour

[JonSwed]

Hi Wizards,

I'm working with Google Analytics data from BigQuery. I've succeeded in extracting hour from my hit time stamps, so now I have a column of whole numbers in a range of 1 - 24. I want to convert these to hours but I'm getting an error when I do so. Is it that it does not expect the presence of 24, and that this should be rewritten as 00?

Any suggestions gratefully accepted

[Anonymous]

Hi @JonSwed ,

Can you show some sample data and expected result?

Best Regards,

Jay

[amitchandak]

@JonSwed , Not very clear on the context

Hour = Quotient([col],24)

remaining= Mod([col],24)

Refer if needed:https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...