Excel - How to convert a date in a column and an hour in another column in "dd/mm/yyyy hh/mm" ?

[aurelieberthet]

Hello,

I have a column A with the day of my measures, a column B with the hour in the regarding day of my measures, and I would like to have a single column with day and hour.

Is it possible and how ?

The purpose is to have a simple graphic with the true measures and not a dynamic one which sums the measures.

Thank you for your help.

[#2]

@aurelieberthet 

Depending on your data it could simply be:

=A2+B2

[#3]

@Detlef LewinYes, it works… I have searched a formula for hours without even thinking of this simple trick… Thank you !