In excel date,help to take time part away
Closed
sandy
-
Apr 30, 2010 at 01:10 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 30, 2010 at 06:38 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 30, 2010 at 06:38 AM
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
Related:
- In excel date,help to take time part away
- Popcorn time download - Download - Movies, series and TV
- How to change time in whatsapp - Guide
- How to take screenshot in excel - Guide
- How to change date format in excel - Guide
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 30, 2010 at 06:38 AM
Apr 30, 2010 at 06:38 AM
see your other question at
https://ccm.net/forum/affich-334039-time-part-out-of-date-format
https://ccm.net/forum/affich-334039-time-part-out-of-date-format