Forum Discussion
How to split one row into multiple rows based on time of day condition
Hi geiratatea ,
May I ask what your judgment criteria are?
I don't really understand the results of this line of data:
Why does it span 1 day but it results in Regular for the full time period?
Best Regards,
Dino Tao
Hello and thanks for your reply. The use case here is about calculating ordinary hours and overtime hours which have different price rates. It is rare for a consultant to work more than 24 hours continuously. So the most common thing is that you work 8 hours. But the overtime limits are often set at specific times. Let's say that the hours 176 to 19 give 50% overtime, and the period after 19 gives 100%. And then there are public holidays where there is 100% overtime around the clock.
It is possible that I am complicating the task too much. But simply put, I either have to create a row with different columns for the different intervals to find how many hours from start to finish fall in the different intervals. Or do I have to generate new rows after which the time slips over several intervals.