Forum Discussion
Solved
Time range between a certain time range and how many hours of that certain range
Hello, everybody
I'm trying to automate our employee entries and I faced the following problem.
So if Employee 1 is working rom 12:00 to 20:00, theoretically it's a 8 hours program so it's no overtime.
But what if every hour between 18:00 and 07:00 AM is paid different (better) . What formula should I use to check a time range between another fixed time range 18:00-07:00 for example and how much hours has he been worked from that certain range. In this case, 2 hours.
Please be aware that our employee works also night shift hours, between 22:00 current day and 05:00 the upcoming day. This is a tricky range. I guess we should use the MOD Function for this one
Thank you in advanced. Any help is much appreciated!
I put your question to the Bing chatbot:
To change the range of an Excel table, you can use the Resize command. Here’s how:
- Click anywhere in the table, and the Table Tools option will appear.
- Click Design > Resize Table.
- Select the entire range of cells you want your table to include, starting with the upper-leftmost cell1.
You can also convert a table to a range by clicking anywhere in the table and then going to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range2. Is there anything else you would like to know? 😊
3 Replies
See the attached demo workbook.
Sir,
I hate you! You simplified my "code" with your solution so badly. So I needed to rewrite my sheets. And now it looks so clean and clear.
Thank you! 😂
- Sir,
You just saved me big times. I've been working really hard the last few hours on it.
Thanks a lot!
