aryanaveen
Board Regular
- Joined
- Jan 5, 2015
- Messages
- 104
Hi Guys
please help me with below code
Basically I am trying to combine values from multiple cells to one sentence.
Range B16 has date, Range B17 is time in "hh:mm" format
when I use below code, time is getting converted in to numbers
Range("B7").Value = "I come on " & Range("B16").Value & " " & Range("B17").Value & " with " & Range("D1").Value
Result what I am getting is "I come on Friday, July 31, 2020 0.6375 with Naveen
Expected result - "I come on Friday, July 31, 2020 02:30 PM with Naveen
please help me with below code
Basically I am trying to combine values from multiple cells to one sentence.
Range B16 has date, Range B17 is time in "hh:mm" format
when I use below code, time is getting converted in to numbers
Range("B7").Value = "I come on " & Range("B16").Value & " " & Range("B17").Value & " with " & Range("D1").Value
Result what I am getting is "I come on Friday, July 31, 2020 0.6375 with Naveen
Expected result - "I come on Friday, July 31, 2020 02:30 PM with Naveen