Im having a problem trying to get Excel to work out my overtime over the weekend. i have managed to do the formula for time and a half overtime from monday to friday but i get paid double time once i've worked over 6 hours on either saturday or sunday.i've tried over and over to get it right but i cant work it out. i've attached a small copy of what im trying to do. Basically column B and C are my in and out times, D is how many time and a half hours i've done, E is Double time hours. Once ive worked 6 hours on saturday my pay goes from time and a half to double time, then when i work on the sunday the whole day will be on double time. But if i dont work on the saturday i only get double time on the sunday once i've done 6 hours. thanks in advance if anyone can help me.
Bookmarks