add/subtracting date:time in Excel 2000
 

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

add/subtracting date:time in Excel 2000
 

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

add/subtracting date:time in Excel 2000
 

dates are saved in Excel internally as 'Long' - with the value being the
number of days from 30/12/1899 to the date used. Time is saved internally as
the decimal part of a day..thus Date/ime is 'Double' This means that 12 noon
os 0.5, 9pm is 0.75

The net of it is that to get the difference in days/time, all one has to do
is subtract on date from another and format it correctly.

A1 31/5/2005 4:00
A2 17/9/2003 17:00
A3 = A1 - A2
621.458333 format to "0 ?/24" this becomes 621 11/24

change A2 to 17/9/2005 17:00
then A3 shows -109 13/24


HTH
"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

add/subtracting date:time in Excel 2000
 

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