I have a date set where the hour of purchase is given as a proportion of 24 hours, so 0.5 is noon for example.
Now, I want to convert these proportions into a normal time with hours:minutes. Does anyone know how to achieve this?
Thanks in advance!
I have a date set where the hour of purchase is given as a proportion of 24 hours, so 0.5 is noon for example.
Now, I want to convert these proportions into a normal time with hours:minutes. Does anyone know how to achieve this?
Thanks in advance!