Step 2: Set Your Time Data Type . Before you add any calculations or checkboxes, you need to tell Excel that certain columns (in my case, columns D, F, and G) will output a time by changing the ...

Understanding Excel's date and time serial numbers can help in calculating differences between dates, ... In this example, you want to find out the time after adding 12.5 hours to 7 PM.