Previous Topic Next Topic

In excel date,help to take time part away

Closed
sandy - 30 Apr 2010 à 01:10
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 30 Apr 2010 à 06:38

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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
30 Apr 2010 à 06:38
see your other question at
https://ccm.net/forum/affich-334039-time-part-out-of-date-format