Exam 77-427 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.3  Apply Advanced Date and Time Functions: Calculate Duration

Calculate the Duration Duration is the number of hours, minutes and seconds from the Start Time to the End Time.   3. Try it: Calculate the Duration Select Cell L2 and type:=K2-J2, Where K2 is the End Time and J2 is the Start Time.   Please AutoFill this formula from L2:L70. (all of the Rows in this example)   4. What Do You See? The formula and the answer are correct. However, the formatting--8:30:00 AM--is confusing.   Keep going... Home->Number->Time