Place a Dynamic Date + a Certain Time in a Cell
 

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

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

Place a Dynamic Date + a Certain Time in a Cell
 

=TODAY()+TIME(10,30,0)
Format the result apropriately (perhaps dd/mm/yy hh:mmAM/PM)
--
David Biddulph

"Sean" wrote in message
ups.com...
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

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