Hi,
Can anyone help me convert this Jul 04 2016 13:43:20 into this dd/mm/yyyy hh:mm AM/PM??
Thanks!
Hi,
Can anyone help me convert this Jul 04 2016 13:43:20 into this dd/mm/yyyy hh:mm AM/PM??
Thanks!
With Jul 04 2016 13:43:20 in A1 try this.
=DATEVALUE(MID(A1,5,2)&" "&LEFT(A1,3))+TIMEVALUE(RIGHT(A1,8))
If posting code please use code tags, see here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks