View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen Stephen is offline
external usenet poster
 
Posts: 106
Default Adding dates & times

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