Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-800471%22%20slang%3D%22en-US%22%3EExcel%20-%20How%20to%20convert%20a%20date%20in%20a%20column%20and%20an%20hour%20in%20another%20column%20in%20%22dd%2Fmm%2Fyyyy%20hh%2Fmm%22%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800471%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20column%20A%20with%20the%20day%20of%20my%20measures%2C%20a%20column%20B%20with%20the%20hour%20in%20the%20regarding%20day%20of%20my%20measures%2C%20and%20I%20would%20like%20to%20have%20a%20single%20column%20with%20day%20and%20hour.%3C%2FP%3E%3CP%3EIs%20it%20possible%20and%20how%20%3F%3C%2FP%3E%3CP%3EThe%20purpose%20is%20to%20have%20a%20simple%20graphic%20with%20the%20true%20measures%20and%20not%20a%20dynamic%20one%20which%20sums%20the%20measures.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-800471%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800522%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20How%20to%20convert%20a%20date%20in%20a%20column%20and%20an%20hour%20in%20another%20column%20in%20%22dd%2Fmm%2Fyyyy%20hh%2Fm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800522%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391044%22%20target%3D%22_blank%22%3E%40aurelieberthet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20your%20data%20it%20could%20simply%20be%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DA2%2BB2%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-800550%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20How%20to%20convert%20a%20date%20in%20a%20column%20and%20an%20hour%20in%20another%20column%20in%20%22dd%2Fmm%2Fyyyy%20hh%2Fm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-800550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3EYes%2C%20it%20works%E2%80%A6%20I%20have%20searched%20a%20formula%20for%20hours%20without%20even%20thinking%20of%20this%20simple%20trick%E2%80%A6%20Thank%20you%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E
aurelieberthet
New Contributor

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 Replies

@aurelieberthet 

Depending on your data it could simply be:

=A2+B2

 

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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies