I have a string field that shows hours, minues, seconds in the following format HH:MM:SS. This field does not map to an actual time format because the hours part could span tousands of hours ie a typical value could be 4458:32:00 which means 4,458 hours, 32 minutes, 0 seconds.
I would like to build a formula which I can use to strip out the hours and minutes values into seperate values which I can perfom a calcualtion to determine the total number of minutes. ie hours * 60 + the minutes value.
I've tried using the split command but I am not sure how I can extract the array elements into their own variable.
Anybody have any ideas on how to handle this?
I would like to build a formula which I can use to strip out the hours and minutes values into seperate values which I can perfom a calcualtion to determine the total number of minutes. ie hours * 60 + the minutes value.
I've tried using the split command but I am not sure how I can extract the array elements into their own variable.
Anybody have any ideas on how to handle this?