Thanks that helped. Sometimes when the obvious doesn't work, do the opposite. Like find the formula that fixes the error J
And thanks for catching my error in column T. Reminder: don't use your personal email to reply to a question. When you do it , your answer won't post to the group. ~Susan From: mgaler [mailto:mga...@sbcglobal.net] Sent: Saturday, March 19, 2011 1:01 PM To: sunni...@gmail.com Subject: Here is a start Take a look at the function in column U. Format column U to mil. time, the columns holding data to numeric without decimal places. This will point you in the right direction. Not sure why you are summing data instead of counting occurrences in column T, but that is your business. Mark -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
