Hi all,
Is there a quick way to convert Thursday, December 3, 2020 11:03:18 AM GMT to dd/mm/yyyy?
Thanks
Mitesh
Hi all,
Is there a quick way to convert Thursday, December 3, 2020 11:03:18 AM GMT to dd/mm/yyyy?
Thanks
Mitesh
one possible option - based on UK settings and assuming you always have a time zone etc
B1:
=REPLACE(SUBSTITUTE(LEFT(A1,LEN(A1)-4),",",MID(A1,FIND(",",A1)+1,4),2),1,MIN(INDEX(FIND(ROW($1:$9),$A1&123456789),0))-1,"")+0
where A1 holds your string
format resulting datetime value as per requirements using standard formatting options
XLent, This is perfect!
Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks