Anisette,

you need to tell Excel that you want the (numerical) value of your
result, so change your formula to:

=VALUE(C1&"/"&B1&"/"&A1) + D1/24

and format the cell as dd/mm/yy hh:mm, then copy down if needed on
other rows. You do not need to add the ":00:00".

Pete