how can add date this formula convert military time to normal time

please i have date in B3 want to add to this formula
=TIME(TRUNC(B4/100),MOD(B4,100),0) instead make convert in one cell then in other sum
i try the following but not work
=TIME(TRUNC(B4/100),MOD(B4,100),0)+b3

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

thanks for your reply
please see my attahced file
want to make b1 and b2 in one step

Try

=A2+TIME(TRUNC(A1/100),MOD(A1,100),0)

format as dd/mm/yyyy hh:mm (or your desired format)

Right click on the cell A2 -> Format Cell, select what's in the picture attached
Capture.PNG