PDA

View Full Version : Manipulating timestamps



WebGuy
05-16-2006, 03:51 AM
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
05-16-2006, 04:16 AM
Use

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

WebGuy
05-16-2006, 04:32 AM
That worked out nicely . Just what i needed !
:friends: