|
Administrator: Manage Outlook
Home -> Number -> Format
Cells Our goal
is to subtract the Start Time from the End Time. An appointment that
goes from 9 AM to 5 PM is an 8 hour day. You can
format the numbers to make the math easier. For example, 5:00 PM
would be 17:00 hours in military time. Now, the
equation would be: =EndTime - StartTime, or =17:00 PM
- 9:00 AM, or =8 hours
duration 1.
Select Column C, Start Time. 2. Go to
Home ->Cells Group-> Number ->Format Cells. Format Cells looks like a
small arrow in the lower right corner of the Number group.
|
|||
|
| |||
