SOLVED
time into Numeric & in minutes
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
shahnawaz_khan
8 - Asteroid
‎01-17-2025
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Labels:
- Labels:
- Workflow
3 REPLIES 3
18 - Pollux
‎01-17-2025
08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
11 - Bolide
‎01-17-2025
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
 
11 - Bolide
‎02-06-2025
11:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dose this solution works? If yes, please tag my response as Solved.
Thanks,
Sebastian
