Hi All

I am an Excel Newbie and I am trying to create a utilisation report.This will enable a user to select from a number of data validation drop down lists so I can run a report on how much time is spent on what activity and what market segement. The only time element I am interested in is AM or PM so I have tried using named constants equaling 0.5 but cannot get it to sum the column please can anybody help.

Regards Andy C