Thanks a BILLION.... this was really helpful. Hit the mark dead on. Special
thanks to the people at Pearson consulting for taking the time to spell this
out in such detail.

Gordon

"Rowan" wrote:

Have you looked at

http://www.cpearson.com/excel/datetime.htm#AddingDates

Hope this helps
Rowan

"Gordon" wrote:

Looking for a way to add/subtract dates/time values. i.e. date/time
1=6/30/05 08:46:00 and date/time 2 is 6/25/05 14:53:00. Time 2 is different
from time 1 by N-Days; N-hours, N-minutes. value can be either positive or
negetive depending on dates. Once thatrvalue is calculated I want to add it
to another value. Any ideas would be appreciated
Gordon