0

Can I drag down dates with AM and PM?

  1. 22/11/2011 AM
  2. 22/11/2011 PM
  3. 23/11/2011 AM
  4. 23/11/2011 PM

like that?

1
  • 1
    Don't think it's possible, personally i would create 2 columns (1xAM, 1xPM) then merge them together and then sort.
    – HaydnWVN
    Nov 22, 2011 at 12:33

1 Answer 1

3

Yes.

  1. Type your starting date in cell A1 but don't type 'AM' - a date without a time in Excel is effectively 12:00 AM.
  2. Apply a custom number format dd/mm/yyyy AM/PM to cell A1.
  3. In cell A2 enter the formula =A1+0.5 which is effectively 12:00 PM on the same date.
  4. Now you can drag down from A2 and you'll get the sequence you want.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .