work hours

  1. 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...
  2. 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
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. S

    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. 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...
  10. 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...
  11. 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...
  12. 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)...
  13. 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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top