Shazir
Banned - Rules violations
- Joined
- Jul 28, 2020
- Messages
- 94
- Office Version
- 365
- Platform
- Windows
Hi, I hope you all are doing well.
I was looking for a formula that will solve the below picture Example.
I want to get the Cells in "Late" Column if C2,D2,E2 have such format "Late - 11:00 AM" then "Late" should be converted with Date as available in C1,D1,E1 and time should be as it is.
and result would be as = 8/1/2020 - 11:00 AM
I was looking for a formula that will solve the below picture Example.
I want to get the Cells in "Late" Column if C2,D2,E2 have such format "Late - 11:00 AM" then "Late" should be converted with Date as available in C1,D1,E1 and time should be as it is.
and result would be as = 8/1/2020 - 11:00 AM