Regional setting is US.
Do we have to use this formula to remove the time?
=DATEVALUE(LEFT(A2,10))+RIGHT(A2,8)
I am using the same sata/
Thanka
Regional setting is US.
Do we have to use this formula to remove the time?
=DATEVALUE(LEFT(A2,10))+RIGHT(A2,8)
I am using the same sata/
Thanka
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks