Excel- Insert todays date and 8am time 1

[wayneryeven]

Hey all
On a spreadsheet i want to have a cell that has the current date + the time set to 8am.

If i do current date/time it will give me:
28/04/09 17:25

What i would like is for it to show:
28/04/09 08:00

ie. the current date AND 8am as the time. i'm not sure of this can be done, then i thought surely it can be with all the various time/date functions there are.

has anyone got any bright ideas on how to get to this?

Thanks to all for your time and efforts.

 

[SkipVought]

Hi,
[tt]
=TODAY()+Time(8,0,0)
[/tt]
faq68-5827


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}