time into Numeric & in minutes

[shahnawaz_khan]

Hi All

Please help to convert time into Numeric & in minutes. as in below table.

Time	Numeric	Minutes
2:30:00	2.5	150
4:00:00	4	240
0:15:16	0.26	16
36:30:00	36.5	2190
130:30:30	130.5	7830
150:00:00	150	9000

[alexnajm]

This might help: Convert time to decimals - Alteryx Community

Other possibilities:

• Solved: Converting Time to Integer - Alteryx Community
• Converting Time to a number - Alteryx Community
• Solved: How do I convert Hours in time to a number that ca... - Alteryx Community

[Sebastian_Chaieb2 · Accepted solution]

Hi @shahnawaz_khan 

Please try attached solution. I have split Time to 3 columns [HH], [MM], [SS] and used in Formula :

Calculations:

Numeric2: [HH]+[MM]/60+[SS]/3600

Minutes2: ceil([HH]*60+[MM]+[SS]/60)

Hope that it will help.

Best regards,

Sebastian

 

[Sebastian_Chaieb2]

Hi @shahnawaz_khan 

Dose this solution works? If yes, please tag my response as Solved.

Thanks,

Sebastian