Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

time into Numeric & in minutes

shahnawaz_khan
8 - Asteroid

Hi All

 

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

 

 

 

 

TimeNumericMinutes
2:30:002.5150
4:00:004240
0:15:160.2616
36:30:0036.52190
130:30:30130.57830
150:00:001509000
3 REPLIES 3
Sebastian_Chaieb2
11 - Bolide
11 - Bolide

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

pic.png

 

 

 

Sebastian_Chaieb2
11 - Bolide
11 - Bolide

Hi @shahnawaz_khan 

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

 

Thanks,

Sebastian 

Labels
Top Solution Authors