Excel Today's date + 1 with time included

[NormChart55]

Hello All,

I am trying to find a formula that takes into account a certain time that we want to include in a custom format.

The custom cell format is below

m/d/yyyy h:mm AM/PM

Using the formula today()+1 does of course give me the correct date and in the right format, but always goes to 12:00 AM for the time. I am needing this to always be 11 AM. is there an easy fix to include this into the equation?

 

[Joe4]

Try this:

=TODAY()+(35/24)

 

[NormChart55]

Try this:

=TODAY()+(35/24)

Awesome! exactly what I needed, very much appreciated.

 

[Joe4]

You are welcome!
Glad I was able to help.

They secret is knowing how dates and times are stored in Excel. Dates are really just numbers, specifically the number of days since 1/0/1900, with special date formats.
And time is really just the fraction of one day.

To get to the next day, you would simply add "1". To get to 11:00 AM, you would need to add 11/24 (11 hours out of the 24 hours in a day).
So 1 +11/24 = 35/24.