Convert 07:38:24 to mins

The data is inserted into the db like 07:38:24

I'm not concerned about the seconds can I convert this into one variable that is just minutes? The output would be 458

Also, 00:45:55 would be 45
Who is Participating?
mrichmonConnect With a Mentor Commented:
<cfset myTime = "07:38:24">

<cfset myMin =( ListFirst(myTime, ":") * 60) + ListGetAt(myTime, 2, ":")>
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.