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 |
Solved! Go to Solution.
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
Dose this solution works? If yes, please tag my response as Solved.
Thanks,
Sebastian
User | Count |
---|---|
52 | |
27 | |
25 | |
24 | |
21 |