Forum Discussion
Excel date formula for AM & PM at same date (for one month)
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 m...
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
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.
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
- Thanks a lot it worked !!!
