In cell A1 I have the day, month, year, hour, minute, and second a particular
transaction took place. In cell A2 I have the day, month, year, hour, minute,
and second the next transaction takes place. The Start and End dates and
times are used to determine the total number of hours, minutes and seconds
for one transaction. I have the total number of hours, minutes, and seconds
for a given transaction in column A3. If the total time in column A3 is
greater than 12:00:00, I want to return the value of 1 Business Day in column
A4. If the total is less than 12:00:00 I want to return the total hours,
minutes, and seconds in decimal format in column A4. Is this scientifically
possible?