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:
<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>I want it to look have 4:00 time stamp (static) at the end of each date.
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>