Work out overtime hours for individuals

as you probably can tell i am a total newbie at writing macros, how do
i add the macro to personal.xls and then make it available for everyone
to use, also do i have to write the code in visual basic.

The other thing i tried the formula u provided, it gives me th elines i
want, but then doesn't calculate some lines and leaves them as zero
despite there being hours.

If you want to share it with others, Personal.xls is no good. Why don't you
create a new workbook with the macro and a button, and save it as a template
file. Your users can then open that whenever they start afresh.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Fudge" <FudgieM@gmail.com> wrote in message
news:1144680107.549442.39100@i40g2000cwc.googlegroups.com...
> as you probably can tell i am a total newbie at writing macros, how do
> i add the macro to personal.xls and then make it available for everyone
> to use, also do i have to write the code in visual basic.
>
> The other thing i tried the formula u provided, it gives me th elines i
> want, but then doesn't calculate some lines and leaves them as zero
> despite there being hours.
>

column a = staff ref
column b = surname
column c = first name
column d = PT worklog start date
column e = PT worklog end date
column f = pay grade
column g = cost centre
column h = duration
column i = hourly rate

That is the setup of the above example, the duration field shows as
01:30 which i have formatted to [H]:mm. however when i drop the formula
in to column j row j2 it doesn't calculate the total hours for some
staff and shows as zero.