work hours

  1. S

    If formula to calculate worked hours

    Hello! I am trying to calculate my worked hours whilst accounting for my lunch break. I have a 30 minute lunch break if I work more than 8 hours, but do not have a lunch break if I work 6 hours. I want to incorporate this into my formula, so that it will calculate the hours worked and minus the...
  2. M

    Help needed taking my Excel project prioritization tool to the next level. Novice needing advice.

    Hello there, I am attempting to create a project planning and management tool for our workplace. What this entails is obtaining "work hours", an "in date", and an "out date" for each project. The program will divide the number of working hours over each business day that a project may be worked...
  3. J

    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...
  4. Manolocs

    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
  5. M

    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...
  6. T

    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...
  7. L

    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...
  8. M

    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...
  9. O

    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...
  10. S


    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...
  11. A

    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...
  12. C

    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...
  13. J

    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...
  14. P

    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)...
  15. N

    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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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