Solved

Convert 07:38:24 to mins

Posted on 2004-10-12
1
142 Views
Last Modified: 2013-12-24
The data is inserted into the db like 07:38:24

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

Also, 00:45:55 would be 45
0
Comment
Question by:JRockFL
1 Comment
 
LVL 35

Accepted Solution

by:
mrichmon earned 50 total points
ID: 12291728
<cfset myTime = "07:38:24">

<cfset myMin =( ListFirst(myTime, ":") * 60) + ListGetAt(myTime, 2, ":")>
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A web service (http://en.wikipedia.org/wiki/Web_service) is a software related technology that facilitates machine-to-machine interaction over a network. This article helps beginners in creating and consuming a web service using the ColdFusion Ma…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question