|
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:L58.
(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...
Exam 77-888: Microsoft Excel Expert
2010
2. Applying Formulas and Functions
2.4. Apply functions in formulas:
TIME Functions
|
|
| |
