Converting Military Time Integer DataType to Time Datatype and then Add/Substract 45 mins

I have a time field in the integer datatype in HHMM. I want to convert into Time format HH: MM and then I need to add and subtract 45 min from 2 different columns. Can someone help me with that?

So I want to subtract 45 mins from 15:40 pm so my new time should be 14:55 pm similarly, I need to add 45 minutes in 2035 so my new time should be 2120 pm

Date Time

Data Investigation

Accepted answers

All comments

cjaneczko

Verify that the data source is in a string format. Use a selection tool if its not. Then bring in a DateTime tool and use HHmm as the custom format. From there you should be able to do any time related calculations needed with a formula tool.

binu_acs

@xaabz One way of doing this

Sequence_011923.yxmd

xaabz

Still the same issue. Missing records and when I try to add and subtract then only Null values show up

xaabz

Still incorrect. What I am missing here?

binu_acs

@xaabz Can you provide your sample data?

xaabz

Please see the attached

Sample Data.xlsx

cjaneczko

As for the issue with the 2400, you are probably better off changing any instance of 2400 to 0000. It seems to work fine if you convert them all over.

xaabz

I need to add 45 minutes in ARR time and substract 45 minutes from DEPRT TIME

xaabz

What about the other time slots? See the attached pic

binu_acs

@xaabz updated the workflow

Time_010523.yxzp

cjaneczko

Attached is fixed to accommodate any times 2400 and greater.

MilTime.yxmd

cjaneczko

Is the Departure time a String? I had an issue where it picked them up as INT32 and i had to use the selection tool to change it to String for the DateTime tool to work.

xaabz

I had to modify it a little bit but it did work. Thank you so much

xaabz

It was an integer then I had to change to a string in order to finally update to time. However, someone else answered and solved my issue. Much appreciated!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703