![]() ![]() Pay is biweekly and overtime is anything over 40 hours. Each gets 30 minutes for breaks which is not paid. ![]() They work on shifts and the operation is 24 hours. Over 7 minutes to 15 minutes = 1/4 hour 15 We have a client who will pay using the 1/4, 1/2/ and 3/4 of an hour increments as follows:įrom the hour mark to 6 minutes = 0 time paid I have bought a number of books in an attempt to figure this out, and I am still stumped I have included an attachment to help (a picture is worth a thousand words). I have the cell the formula is in, formatted with a "mm,ss" format. This is the formula I am trying to make work. My problem is when I am trying to use a logical "IF' statement to account for the 20 minute break or lunch and still calculate the end of each cycle time through the day I receive a number of error messages. If we start at 6:00 am, the first scheduled cycle completion time = TIME(6,0,0+71.25/1440) Production shuts down for lunch 30 minutes for lunch at 12:30. I am trying to figure out how to write a formula to figure out production cycle time. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |