# Excel/Overtime Hours

Question

time sheet
I'm trying to set up a small spreadsheet. When our employees work our regular hours 7 am to 3 pm they get paid regular pay. But when they work outside those hours they get time and a half. All of our employees get paid the same rate. 15.50 being regular pay and 23.50 being anyother pay. I have attached the spreadsheet that we would like the format to be. So if Nicki works 6 am-4 pm 6-7 and 3-4, 2 hours, would be 23.50 and 7-3 would be 15.50. If Nicki works 7:30 - 4 7:30 - 3 7 1/2 hours at 15.50 and 1 hour at 23.50. I hope I did a good enough job of explaing. I tried to research but all I was coming up with was 8 hours at regular and anything over at time and half. I'm about to give up. Hope you can help. Thanks Nicki

I am a little confused.  Is it the elapsed hours or the time in and time out that cause over time pay?  If I work 6 am to 2pm, 7 hours total, do I get overtime pay of 1 hour from 6 am to 7 am?  Typically, it is the elapsed time and not the time in and time out that determine overtime.

Bill