In excel date,help to take time part away [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-

hi i have query im not able to take time part from date and as below

29/04/2010 10:30 AM, i need only date, i have array as followos

A1 b1 c1
29/04/2010 10:30 am 29/04/2010 3:30PM =if(a1=b1,"SDD","no SDD")

due to time slot im not able execute, if executes its turnout to be wrong out put pl help me

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
763

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!