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

Sebastian_Chaieb2

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

Solution_SC.yxmd