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

[xaabz]

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

[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.

[binuacs]

@xaabz One way of doing this

[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?

[binuacs]

@xaabz Can you provide your sample data?

[xaabz]

Please see the attached

[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