Convert time in decimal [e.g 7.6 hours] to Time in hours and minutes 7:30

Question

Hello All,

I am a newbie to Alteryx .I would like to know how to convert decimal time in hours to time in  hours:minutes(rounded)

E.g I need to convert 7.6 hours to 7:36 (7 hours: 36 minutes)

7.5 hours to 7:30 minutes

6.17 hours to 6:10 minutes

Could somebody please guide.

Thanks in advance

JosephSerpis · Answer

You are going to have to change the datatype from a time format into a string format to achieve and use a left or right formula to extract.

Convert_Decimal_Time_29072023.yxmd

Learner_Kat · Answer

Yes I did divide by 1440.i need it to display as 7:30 and not 00:07:30

Is there a way to change size of the data type time from 8(default)to 4 ( which I am guessing will change the format to 7:30)

JosephSerpis · Answer

Yes divide by 1440 which is the amount of minutes per day.

Convert_Decimal_Time_29072023.yxmd