I was looking for a long time for formulas like that, tried a lot of things but I never could get it to work.Hi all
Sorry if this has already been posted but i can see it
I want to make a time sheet where i type in the start time (A1) and finish time (B1) it will work out the following automatically
1, Total worked worked i have sorted this with [=SUM((B1-A1+(B1<A1))*24)]
2, Hours worked @ Normal rate between 8:30 and 17:00
3, Hours worked @ 1.25 rate before 8:30
4, Hours worked @ 1.25 rate between 17:00 and 24:00
5, Hours worked @ 1.33 rate after 24:00
can anyone help
Now I need one more rate in it, but still I cant get it to work.
The first hour, after 8 hours in the normal rate, needs to be @ 1.125 rate.
After that the 1.25 rate and 1.33 rate again.
Would be very thankful if someone could help me.
Bookmarks