Thread: Place a Dynamic Date + a Certain Time in a Cell
View Single Post
  #2  
Old January 6th, 2007, 10:54 AM posted to microsoft.public.excel.worksheet.functions
Sean
external usenet poster
  
Posts: 162
Default Place a Dynamic Date + a Certain Time in a Cell
Dooh, just worked it out

=TODAY()+(630/1440)


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