1. Format the worksheet. See sample format below. Insert columns for Visitor number and Visit duration. Format the entry and exit columns into date and time as shown below. Use appropriate formula to find out the visitor duration. Visitor No. Mark's Collectibles Site Statistics October - December 2008 Site Add To Connection Favorites Hot Bot Yes No Yes No No No IP Operating Address System 1999 010.210 133 Windows 2999.250.150.140 Linux 3999.111.233.190 Windows 4999.140.152.160 Windows 999 180.007.222 Macintosh 6 999 204 209 208 Linux 7 999 215 233 111 Macintosh 8 999.177.166.144 Macintosh 9999.133.205 212 Macintosh 10 999.101.203.011 Windows 11 999 111 233 190 Windows 12 999 104 202 251 Macintosh 13 999 250.150.140 Linux Exit 10/10/08 11:50 10/3/08 11:31 10/3/08 14:34 10/3/08 14:34 10/5/08 10:41 10/5/08 10:41 10/5/08 14:58 10/6/08 1:28 0/6/08 203 10/7/08 15:33 10/9/08 5:36 10/11/08 4:11 10/11/08 13.02 10/13/08 7:42 10/13/08 18:15 10/13/08 22:51 16:27 14 999.111.233.190 Windows 999.140.152.160 15 999 140 152 1