Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtracting date/time | Excel Worksheet Functions | |||
Subtracting Date/Time | Excel Discussion (Misc queries) | |||
add/subtracting date:time in Excel 2000 | Excel Programming | |||
Subtracting time in date format | Excel Worksheet Functions | |||
Subtracting time in date format | Excel Worksheet Functions |