[robbie73]

Hello all :)
I am trying to create an excel (2003) spreadsheet which basically helps me keep track of my hours. i work for an agency so the rates and hours change daily.

I have these columns
day, date, start time, finish time, days hours, unpaid breaks,
employer, pay rate, total days hours, total weeks hours, weeks pay.

I've managed to use the formula below to get the days hours calculated,
=TEXT(D3-C3,"h:mm")
(where c3 is the start time and d3 is the finish time.)

but i struggle with getting a weeks total and also subtracting unpaid breaks from the calculated daily hours.

It seems that any reference to the cell with the calculated hours just brings up an error such as ##VALUE## . I tinkered with formatting cells but i dont seem to be able to get it to do what i want.

can somebody help with this please. also if i could shoehorn a overtime rate calculator and a rough formula for uk deductions (national insurance and income tax) that would be brill, or a ready made spreadsheet coverng all those things would be even better

I know its not easy and i appreciate any advice or help. Thanks in advance for any replies.

Rob

[simonsmith]

=sum(number * number) enter

[robbie73]

Thanks for replying simonsmith. I've not had time to do anything this week but i'll give it a go later