Manipulating timestamps

[WebGuy]

Hello!
I am sure that this will be an easy problem to solve for those of you more experianced than me (3 weeks of VB).

I have a script that loads values from a database. Every value gets a timestamp in tha format "YYYY-MM-DD 16:00:00".
I would like to to be able to write todays date "=Now()" with 16:00:00 as the time so it matches the downloaded timestamps.
Does anyone know how to do this ? Any help is greatly appriceated.

//Webguy.. have you ever seen a more laughable handle ?? I just made it up.. WebGuy .. tsssk ..

[Bob Phillips]

Use

=TODAY()+TIME(16,0,0)

[WebGuy]

That worked out nicely . Just what i needed !