Hello penzalmendra,
VBA stores a Date and Time as a single number. The Date is the integer part and the Time is the fractional part of the number. The date starts from December 31, 1899 or 1. The time is in seconds since midnight or zero hours. One second would be 1/86400.
The values in column "C" are Time values (decimal fractions). These can be added directly to the Date in column "B" to produce a "complete" date/time value. The values in column "AS" need to be converted from an integer into a Time value in hours before it can be added to the date/time sum of "B" and "C". This done using the TimeSerial method. This converts Hours, Minutes and Seconds into a fractional Time value.
Corrected Equation
Bookmarks