working hours

  1. F

    Correct Formula to calculate working hours between Time in and Time out

    Hi, What is the correct formula to calculate working hours between Time in and Time out
  2. J

    Calculate only working hours between two dates with several constraints (includes weekend, excludes holidays, working hours ranges different each day

    Hi all, I have read many threads regarding the calculation of working hours between two dates, including the following thread https://www.mrexcel.com/forum/excel-questions/426101-calculate-only-working-hours-between-two-dates-excluding-weekends.html and the great answers from member barry...
  3. J

    Calculating Working Hours /w Date+time stamps and a variable

    Hi Guys, I am trying to write a formulae that will calculate the working hours between two date + time stamps formatted "dd/mm/yyyy hh:mm:ss", but I also need it to factor in the schedule type of the entree, of which I have three located further along the row: - 24/7 (where all hours are...
  4. S

    Adding hours to datetime within varied working hours + past midnight

    Hello everyone, My first post here, I've searched the forums extensively for a past week but couldn't find exactly what I'm working on. Unfortunately my case has some weird details . I'd like to ask you for help as I'm stuck right now. Here's the table showing what I mean: <tbody> start...
  5. I

    Formula for sharepoint to calculate hoours

    Hello, Formula works in excel .. but not in sharepoint. Not sure i've posted in correct forum for sharepoint, i viewed similiar thread in this forum. Need to extract total business hours worked between 2 dates\time (Date and time format)...
  6. M

    Calculate elapsed time with a date table

    Hi, folks, Is it possible calculating an elapsed time with a predefined date table of working hours? For example: I want know an elapsed time of a process between 01/07/2016 09:00 and 10/07/2016 17:00 using this table: <tbody> Date Start time End time 01/jul 08:00 18:00 02/jul 06:00...
  7. H

    Another complex working hours formula

    Hi! I am creating a template which consists the following: Start Date & Time - contains a start date and time End Date & Time - contains a end date and time nwday1 - Named range (contains non-working 1 day OR first weekly off, it accepts a number from 1 to 7) nwday2 - Named range (contains...
  8. T

    Calculate time between two dates when working hours are mon-fri08:00, sat 08:00-14:00

    Hi All I am desperate for a solution and running out of time so would appreciate any help on this. i have an SLA to measure on how much time our help desk has spent on a call. I need to calculate the time in DD:hh:mm:ss between two dates. A start date and time and an end date and time. However...
  9. S

    How to calculate completion date/time ignoring nonworking hours

    Known Variables A1 = start date and time (6/16/15 6:00AM) B1 = estimated hours to complete work order (15) Work schedule is 6AM to 6PM, weekdays only What formula can I use to calculate the end date/time, ignoring nonworking hours? It currently says that the estimated completion will be...
  10. J

    SLA - Based on varying priority, add time to a date excluding non working hours

    Hi If a job is logged at 13/03/2015 16:00:00 (a Friday), and is priority 1, then the job must be completed within 24 working hours. If a job is logged at 13/03/2015 16:00:00 (a Friday), and is priority 2, then the job must be completed within 48 working hours. (there are 5 priority levels) I...
  11. T

    Calculate working hours excl weekends and holidays

    I need to calculate the number of working hours between two dates excluding weekends and bank holidays. I found the following formula online somewhere and thought it was working brilliantly, but it doesn't seem to be excluding Saturdays...
  12. K

    Count working hours between 2 dates excl weekends either with formula or function

    Hey all, I know I can find the answer to my question on quite a few places but I've tried most I find and they just don't work. Don't mind if its a formula or function though. example of what I tried for example is...
  13. C

    working hours formula

    Good afternoon. I have a .csv file that I have downloaded from my company ticketing system. The way the data is formatted is of little use and I need to manipulate it to retrieve any information from the data. The report records at what time of the day tickets are created. What I'd like to do is...
  14. T

    Excel Grade of Service / SLA formulas

    Apologies I'm very very new to excel formulas etc. so please be patient with me </SPAN></SPAN>:) I have a spreadsheet which contains raw message stats and need to be able to work out if each message received is within 1 hour SLA however I'm not sure the best way to do this or easiest. In...
  15. myactiondesign

    Calculating Holiday Pay // Rota Scheduling

    Hello everyone and anyone that can help. I'm looking for some help to calculate holiday hours using an "H", or meeting hours using an "M", in a time cell instead of an hour to state that it is a holiday day, and distinguishing these hours from standard working hours to create two different...
  16. P

    system idle time using timer

    Hello all, I am currently working on a project where I need to count system Idle time through the working hours, i have checked most of the codes available online but no success :mad: I am having a simple code which i am currently using where user need to start the timer once he start working...
  17. K

    Calculating Difference in Time with 2 set of Working Hours

    Hi I have been trying to find a formula that will help me monitor one of my suppliers performance. I need to calculate the number of working hours/mins it takes them to attend site from an initial call being logged. The complicating factor is that this can span all 7 days of the week, but the...
  18. H

    calculate time taken for a job to complete

    Hi I need a formula to calculate the business hours taken to complete a job. The job runs over a few days but only during business hours. I have calculated the time difference by subtracting the the 2nd date time from the 1st but that gives me total hours, i need just the business hours...

Watch MrExcel Video

This Week's Hot Topics

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.
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 "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
Top