Forum Discussion

jpbourdin's avatar
jpbourdin
Copper Contributor
Sep 17, 2024
Solved

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 month)?

  • 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

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor

    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.

    • jpbourdin's avatar
      jpbourdin
      Copper Contributor

      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.

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        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

Resources