Previous Topic Next Topic

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

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:

1 response

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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Facebook says I have been trying too often
Sameer -
owilson -

2 responses