Place a Dynamic Date + a Certain Time in a Cell
Try this:
=TODAY()+"10:30"
Format cell as: dd/mm/yyyy h:mm
"Sean" wrote:
I might be stupid but I can't figure out how to return TODAY + a
specified time in a Cell
What I want to achieve is TODAYS date (this changes daily) and a
specified Time. So for example I wish for today to show 06/01/07
10:30am; tomorrow will show 07/01/07 10:30am
Thanks
|