Excel date formula for AM & PM at same date (for one month)

[jpbourdin]

Hello, I saw in format Cells you can select date / 4/3/12 1:30PM and then go agan in the cell to personalize, but how it is working to have for instance 01/10/2024 AM and 01/10/2024 PM (... for the month)?

[#2]

@jpbourdin 

Format the cell as a date and time:

First select the cells or area you want to have the format, then…

Right-click the cell and choose Format Cells.

Under the Number tab, select Custom.

Use the format:  dd/mm/yyyy hh:mm AM/PM or mm/dd/yyyy hh:mm AM/PM depending on your region.

This will display the date with either AM or PM next to it.

Hope this will help you.

[#3]

@NikolinoDE 

Thanks for your quick answer but it seems that i didn't understood well, or it doesn't work as i would like.

I managed to put the right date in B4 but when I try to expand it on the right i woud like 01/10/24 PM.

I went to cell to customize but the result doesn't feet.

And in D4 i woul like 02/10/24 Am, in E4 02/10/24 PM... til the end of the month.

[#4 · Accepted solution]

@jpbourdin 

Enter 1-Oct-2024 in B4.

Enter the formula =B4+0.5 in C4.

Fill to the right from C4.

Select the entire range and apply the custom number format   j/m/aa AM/PM

[#5]

Thanks a lot it worked !!!