Excel 2007 : Need help with wages form

Hello.
This is my first time doing anything in Excel. I can't get my wages form to work.

Can anyone help me getting a cell to show total hours?
Im sorry this file is in Icelandic, but you should figure this out easily.
Here are some translations:

Kom - Came
Fór - Left
Hlé - Break
Tímar - Hours
Samtals - Total
Yfirvinna - Overwork
Tímakaup - Wages p. hour

When the hours reach 120, overwork starts. Overwork is 40% higher than normal.

Here is the url:
https://files.getdropbox.com/u/65493/vinnaforums.xlsx

If you want to help, than please fix it and reupload, or just tell me what I am doing wrong.

Thanks in advance!

Br.
Opes

This a little more standard layout, I think.

The dates will fill themselves out, just put in the first date of the month in A5.

Þú ert velkominn. Bestur vilja og hamingjusamur computing.
(You are welcome. Best wishes and happy computing.)

Ef þessi tekur standa ekki á sama þinn þörf , þóknast ritstýra þinn frumeintak skilaboð , "GO ADVANCED" og breyting "PREFIX" kassi til [SOLVED].
(If that takes care of your need, please edit your original message, "GO ADVANCED" and change "PREFIX" box to "SOLVED".)

On the second sheet, you can list all the holidays you observe, those dates will not appear in the date listing.

Then on the TimeSheet, select the MONTH in B2, the rest of the days will appear, no weekends and no holidays.

I suppose you could copy the second sheet lists to the first sheet to get it all on one sheet, your call. I use "Named Ranges" for the months and the holidays to make the formulas easier to read.

No, the WORKDAY() function specifically lists only Mon-Fri.

Post up your sample sheet pointing out specific dates you think should be there. Here's the sheet showing April, and I put in another column to show the dates I see when i load it on my computer.

Well, if the same sheet lists one set of dates on my machine, then you open the same document and get a different set of dates, I'd expect it's the local operating environment. Something about the regional settings in the OS/Excel are causing unexpected results.

I'm sorry I can't suggest anything else. Maybe someone else will have an idea.