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

Question

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

Report

sandy - Apr 30, 2010 at 01:10 AM
rizvisa1

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

- 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

In excel date,help to take time part away
Excel duplicate each row x times ✓ - Forum - Excel
Excel - Insert current date or time - How-To - Hardware
Excel - Concatenate the date with time - How-To - Excel
Excel repeat a number x times - How-To - Excel
Copy row and insert n times ✓ - Forum - Office Software

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-04-30T06:38:13-0400

Answer 1 / 1

rizvisa1

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

763
Apr 30, 2010 at 06:38 AM

see your other question at
https://ccm.net/forum/affich-334039-time-part-out-of-date-format

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

1 reply

Your reply

Subscribe To Our Newsletter!