I am in the middle of a project and have hit a brick wall.

I have a dataset that exports from Access to Excel. The data in Access has a calculated field that needs to be calculated further and Access just wont cope with it.

The data that comes across to Excel is 7 columns wide and length (no. of rows) is variable for each team (my target group). Of these columns the 5th column needs to be calculated (its a work-time thing). Column 5 "Total Time" = Column 3 "End Time" minus Column 2 "start time" and minus Column 4 "Breaks". Column 5 needs to be totalled at the end.

I've tried "used range" but it only picks up cols 1 - 4. It totall ignores cols 6 - 7 and I can't get the righ calc to appear in Col 5, nor can I get it to total at the first empty cell at the bottom of the column.  Any suggestions on how to make make both parts of this work - (not looking for someone to script this, I'll have a go myself, just looking for the right direction with a split range)? I have to hand the reports up to the boss on Tuesday and have 157 teams (nationally) to do reports for, so any help would be much appreciated.

Doubled  

[Edited by Doubled on 10-02-2007 at 07:22 AM GMT]

[Edited by Doubled on 10-02-2007 at 07:22 AM GMT]