# work hours

1. ### Creating a time card with overtime and double time please help me i need to finish this

Hello friends Thank you very much in advance to anyone who helps me on getting this time card ready, ive been trying and trying different methods and i just cant figure it out.. I am creating a time card for my work as i cant punch in or out in office, i have to do it at home and then email it...
2. ### Calculate meal allowances

Hello, How can I calculate the total of each allowance the employee is entitle during the given period? Start Time: 22/Mar/17 12:50 End Time: 30/Mar/17 18:50 Breakfast Between: 7:30 and 9:30 Lunch between: 12:30 and 14:30 Dinner between: 19:30 and 21:30 Thanks in advance
3. ### Percentage of work over time

Hi Experts, I am having trouble displaying work as a percentage over time. I tried several things but I can't seem to figure it out. I have the following tables: <tbody> People PersonID Name Title 1 John Manager 2 Jane Manager 3 Tom Analyst Work...
4. ### Calculating end time from a duration excluding break.

I am currently using a calculation from an older post to calculate end date time using a start date time and a duration. This formula excludes weekends and accounts for a 18hr production day...
5. ### Complicated work schedule log calculations.

So, I have a work log that looks kind of like this.... Start 9:00am -stuff -more stuff Stop 3:30pm Start 4:30pm -even more stuff Stop 6:30pm Start 9:30pm - lots more stuff End 1:00am Occasionally it will look like this... Start 7:00am - too much stuff Stop 3:00am I'm copying it...
6. ### Sum of work hours between two dates with changing shifts

Hello, I've tried how to calculate how many work hours were there between two dates when I have one work time during regular workdays and another work time during weekend (let's say Saturdays and Sundays have same work time for this example). So I want to calculate how many working hours...
7. ### TIme Sheet Restricting Entry to only allow 5 workdays instead of 7

Hello, I am setting up a time sheet for my employers to use. There are 7 days in a week but I want to set it up in such a way that the user can only input work hours for 5 days a week and prohibit them from inputting anything on the other 2 days. For example, if Employee A worked Mon-Fri, then...
8. ### HELP! EXCEL PROCESS TIME and BREAKS CALCULATION

Hi, I'm looking for a way to calculate my working time spent for every type of process minus the total time spent on every type of break if I had it during that time range. I want excel to determine if I had a break while still working on a type of process. For Example: #1: I started to...
9. ### formula to Calculate Working Times between two dates and time - help needed

Hi all, I want to calculate Working time, which only include time from 09:00(9am) to 18:00 (6pm) on weekdays Monday to Friday only. I m using this Formula I want a formula that can correctly calculate time spend in all the folowing scenarios. > If Start Time is on week day in working hours...
10. ### Subtracting Work and Overtime...

Ok, I have created a fairly large spreadsheet that figures all the work time for employees, including sick time, holiday, vacation, etc. My question is the way I currently have this set up, time is based on a day by day basis, i.e. Mon-Fri, and if someone were to work more than 8 hours, it would...
11. ### Help Needed with Scheduling Spreadsheet

Hello! I have a question about creating a formula that will tell me--based on two different schedules, including different scheduled hours and different scheduled days--how much overlap time there is between two different work schedules per week. Here is the example: I work from 7:00 - 16:00...
12. ### Calculate future working date and time

My worksheet includes the ff: E11: 0.0416666666666667 (in days) --> basically, this is 1 hour F11: Start Date/Time (3/24/10 4:50PM) G11: End Date/Time What I would like to happen is to add E11 to F11 taking into account that it should only add working days and working hours (8:00AM to 5:00PM)...
13. ### Negating Work days and Work Hours from set response periods

Hello, I have the challenge of calcuting response times within 1 working day for cases filed by my clients. My current function does not account for workdays and holidays. So if a case is filed on a Friday evening and I respond on Monday morning, I have missed my allowed response time window...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back