If the times are not stored in Date datatypes already then use CDate to convert them from strings. Use CDbl to convert DateTimes to Doubles, where the integer part represents days and the fractional part represents fractions of a day. Add the fractional parts and check for a day overflow.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?' Drive a Steam Roller
That's very confusing. Do you want to add 20 hours to 10am?
You could use the DateAdd() function to add hours, minutes, seconds, or days, but you have to convert the values first.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.