Fudge wrote:
> bob can this formula be written into a macro, so that on a monthly
> basis when i print the list i can simply apply it to open into a new
> work sheet with the figures as i need them? rather than having to write
> out the formula every month

Hi the fields that are used are as follow:

Staff`Ref Surname First NAme PT Worklog Start PT Worklog End Pay
Grade Cost Centre Ref Duration Hrly Rate (columns A-I) so column J
would contain the total for total hours worked for each individual
(multiple lines) what bits do i need to change on the formula, the
duration shows as 01:30, 00:30, 06:00