Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
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 '11 at 12:33

1 Answer 1

up vote 3 down vote accepted

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.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.