![]() ![]() In the example you have given START_DATE =, START_TIME = 17:00, END_DATE =, END_TIME = 23:00, bonus1 start time = 20:00 in this case the time difference between 23:00 and 20:00 will be at bonus payment.Ħ. You also have a bonus time you mention a bonus1 start time and a bonus1 end time why do you need a bonus1 end time ? I would think that if the END_TIME is beyond the bonus1 start time, then the time difference between the END_TIME and the bonus1 start time will be at bonus payment.ĥ. In this case, we can have two possibilities :Ī) The difference between the two times is less than 24 hoursī) The difference between the two times is greater than 24 hours.Ĥ. Normally, if the two times are on the same date, the END_TIME will be greater than the START_TIME if not, it means that there has been a midnight crossover. We need to find out the difference between the END_TIME and the START_TIME.ģ. You have a START_DATE, START_TIME, END_DATE, END_TIME.Ģ. Would appreciate some help I am not an expert so forgive me if I ask some questions (formula used from previous question answers on this site)ġ. ![]() I cannot get it to work properly because it crosses midnight ![]() The cells used for bonus2 start time aj2, finish time ak3 are used instead of ah2 and ah3 and just changed in the formula. The problem comes when I try to use the formula to work out the second bonus period which is from 23:00 to 06:00 the next day. I have used cells for start date w23, start time x23, finish date y23, finish time z23, bonus1 start time ah2, bonus1 finish time ah3, using the following formula he has worked 6hrs and 3 hrs of which are at a special bonus. The problem is as follows, I have been working on time sheet to calc pay.Įxample 1 - If a person starts shift on 15/10/11 at 17:00 and works to 15/10/11 23:00 then the time he works falls in to a bonus period 20:00 to 23:00 i.e. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |