Hi There,
I am working on a spreadsheet that calculate the following -
Monday to Friday - the first 8hrs are Ord Hrs, then the next 2hrs is Time and a half the the following 2hrs is Double Time.
Saturday = first 2 hrs is time and a half then rest is Double Time.
Sundays = Double Time
I have a spreadsheet that has a 7 day week with 8 employees listed and I enter the amount of hrs they worked.
Then in the other columns I have to try and calculate the above rules with. I don't need dollar amounts but just the total hrs each week.
At first I thought it would be just as easy to do it manually but through if a calulation is done then it's as easy as entering the 12hr times in and the spreadsheet doew the rest, also if the person fly's from site on certain day then it will only show 4hrs for that day which is ordinary hrs.
If you have any ideas what function i should use or work out the calculation that would be great.
Sunday Monday Tuesday Wednesday Thursday Friday Saturday SCHEDULE OF RATES $7.18 $38.98 $58.47 $77.96
3/03/2013 4/03/2013 5/03/2013 6/03/2013 7/03/2013 8/03/2013 9/03/2013 FI FO Hrs Total SITE ALLOWANCE ORDINARY TIME TIME AND HALF DOUBLE TIME
12 12 12 7 12 FI 4 0 55 55 7 24
0 0 0 0 0
0 0 0 0 0
I can send the spreadsheet if need be.
thanks
Felicity
Bookmarks