Highlighted

## How to convert minutes to decimal

Participant ,
Jun 30, 2014

Copied

I need to convert my minutes in my HH:MM record to decimal.

For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours

and if i have 10 hours and 30 minutes I need to return 10.50 hours.

How do I do this?

TOPICS
Getting started

Views

428

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

## How to convert minutes to decimal

Participant ,
Jun 30, 2014

Copied

I need to convert my minutes in my HH:MM record to decimal.

For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours

and if i have 10 hours and 30 minutes I need to return 10.50 hours.

How do I do this?

TOPICS
Getting started

Views

429

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 30, 2014 0
2 Replies 2
Most Valuable Participant ,
Jun 30, 2014

Copied

 How do I do this?

Longer answer: parse it using list functions and then do some math.  Like this:

```<cfset MyTime = "43:15">
<cfset hours = ListFirst(MyTime, ":") > <!--- get the hours part --->
<cfset minutes = ListLast(MyTime, ":") > <!--- get the minutes part --->
<cfset decimalMinutes = minutes / 60 > <!--- Calculate minutes as decimal of an hour --->
<cfset MyDecimalTime = hours + decimalMinutes > <!--- Put it all back together as decimal hours --->
```

Or, in more terse form:

```<cfset MyTime = "43:15">
<cfset MyDecimalTime = ListFirst(MyTime, ":") + (ListLast(MyTime, ":") / 60) >
```

HTH,

-Carl V.

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jun 30, 2014 0
LATEST
Jul 01, 2014

Copied

If you need to round off to 2 decimals and to pad with 0s, that is, 10.50 instead of 10.5, then adapt Carl's solution to

<cfset MyDecimalTime = numberFormat(ListFirst(MyTime, ":") + (ListLast(MyTime, ":") / 60), "00.00")>

Likes

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 01, 2014 0