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
thank you
kevin
Bookmarks