Converting Decimal minutes (time) to mm:ss

Question

I am trying to figure out a way inside ArcGIS to convert the OD Cost matrix field "Total_TravelTime" from decimal minutes into the mm:ss format.  In the past I've pulled the data out and into Excel and done it there using the ="Minutes" formula.  But would love to cut out that step if it can be done with python or some sql coding.

RobertBorchert · Answer

Create a new field and give it the DATE property

Field Calculate the new field with <decimal time field> / 24

It will automatically format it to HH:MM:SS

RobertBorchert · Answer

What is the code you use in Excel?Thanks for your help Melinda--
I am trying to do a Calculate Field function, but not being a "code" person, am trying to figure that piece out.  Just trying to format the decimal value of 1.5 to look like 1:30.  Will keep searching or just export to Excel.

PaulMorgan · Answer

Thanks for your help Melinda--
I am trying to do a Calculate Field function, but not being a "code" person, am trying to figure that piece out.  Just trying to format the decimal value of 1.5 to look like 1:30.  Will keep searching or just export to Excel.