Hi All,
I have three cells.
In one cell there is Date, in 2nd cell there is time and in last cell there is AM/PM.
I wanted all of them in one call so I concatenate them but after that I am getting result as 45300 0.486006944444444 AM.
Can anyone please help me. How can I change it to Date and Time Format?
I have three cells.
In one cell there is Date, in 2nd cell there is time and in last cell there is AM/PM.
I wanted all of them in one call so I concatenate them but after that I am getting result as 45300 0.486006944444444 AM.
Can anyone please help me. How can I change it to Date and Time Format?