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:

[TABLE="width: 87"]
<TBODY>[TR]
[TD]Expiry</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]8/17/2012</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]7/20/2012</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]8/17/2012</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]</SPAN>[/TD]
[/TR]
[TR]
[TD="align: right"]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL></COLGROUP>[/TABLE]
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!