# working hours

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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...

### 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