Hi,
I am facing issue to get the result of Regular hours and over time based on the following conditions.
Input is as:
A1 = Start Time
B1= End time
Conditions as:
<tbody>
</tbody>
I would like to get the formula that is for each column (as mentioned above). Suppose a person worked from 8:00 AM to 9:00 PM then its regular hours will be in regular hours column and over time in 1x and so on.
There may be a chance a person worked from 8:00 AM to 7:59 AM for 24 hours so each column will contains related hours.
any suggestion ?
I am facing issue to get the result of Regular hours and over time based on the following conditions.
Input is as:
A1 = Start Time
B1= End time
Conditions as:
Regular hours | Over Time (1x) | Over Time (1.5 x) | Over Time(sunday- 1.5x) | Over Time Sunday(2x) |
8:00 AM to 5: PM | 6:00 AM to 7:59 AM | 9:00 PM to 5:59 AM | 6:00 AM to 9:00 PM | 9:01 PM to 5:59 AM |
5:00 PM to 9:00 PM |
<tbody>
</tbody>
I would like to get the formula that is for each column (as mentioned above). Suppose a person worked from 8:00 AM to 9:00 PM then its regular hours will be in regular hours column and over time in 1x and so on.
There may be a chance a person worked from 8:00 AM to 7:59 AM for 24 hours so each column will contains related hours.
any suggestion ?