A2 is not a valid date and time in Excel format. It would work if A2
contained (for example) either =1+"3:00" or 27:00
--
David Biddulph

"Stephen" wrote in message
...
That should be "add time to a field", and the resultant in the example
should
be 2007-11-15 00:13.

"Stephen" wrote:

G'Day,

I would like to be able to time to a field with a date & time. For
example:

A1 = 2007-11-13 21:13
A2 = 1 3:00:00
A3 = A1 + A2

This gives an error. I've looked over the DATE and TIME related
functions,
and nothing seems to address this specifically.

Help!

Thanx