- 1). In Excel, enter the following in Row 1, from columns A through E: Name, Subject, Call Start, Call End, Duration.
- 2). Select cells C2 through E2. Right-click and select "Format" then "Cells," and make the cells have the Date format. Selecting a date format with a 24 hour clock makes many things easier to follow for someone else who has to evaluate the call log, but is not strictly necessary.
- 3). Click on the Data tab in Excel 2007, and select "Data Validation." In the dialog that comes up, select "Time" from the first drop-down, let it remain at "between," and select a start time of 00:00, and an end time of 23:59. This ensures that these cells can only have times put in them.
- 4). Enter the following formula in cell E2: "=MOD(D2-C2,1)." This gives the duration of the call; the =MOD() function ensures that a call that starts before midnight and ends after midnight gives the correct duration.
previous post