Inserting a changing date and a static time

[nadaraza]

Hi...trying to find a way to insert/format the date in excel to be today date (will change everyday) but the time must be static at 4pm or 16:00. It defaults to 00:00 or 12:00AM so if theres a way please let me know.

E.g i have on column with dates:

Expiry</SPAN>

8/17/2012</SPAN>

7/20/2012</SPAN>

8/17/2012</SPAN>

</SPAN>

</SPAN>

</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

I want it to look have 4:00 time stamp (static) at the end of each date.

 

[VoG]

Try

=TODAY()+"04:00"

Format as Custom, dd/mm/yyyy hh:mm

 

[Darren Bartrup]

Try:

=TODAY()+0.6666666667

 

[nadaraza]

Nice. Thanks guys. Easy fix... Both work!