Dear folks I tried the following formula to cacluate the date and time but currently its only showing correct date with wrong time how to fix it
Monday, June 15, 2020 10:08:12 AM forumula I used =DATEVALUE(MID(E2,FIND(",",E2)+2,99)) then it convert in digit 6/15/20 12:00 AM
Thursday, June 18, 2020 4:12:57 PM` 6/18/20 12:00 AM
Time is always showing 12:00 AM how to fix it ?
Bookmarks