Calculating elapsed time,respecting working hours.

I am looking for a formula to calculate time from one date and time to another. The only catch is I only want it to use times during specific times.


Example

Start 5/1 8am and end 5/2 8am. The working hours are from 7am until 4pm and from 8pm till 5am. In this example the solution should be 17 hours.


How do I set up a formula to respect only working hours (also excluding weekends except for Saturday early am from midnight until 5am.


Sorry if this is confusing, I am trying to use IF statements but I’m fighting a losing battle.

Thanks!

CoryX

Put together 5-10 sample time calculations showing the times and what the result should be. Make sure your sample set of data FULLY demonstrates all the hurdles to overcome and show the logic when it is isn't obvious.

Click on GO ADVANCED and use the paperclip icon to post a sample sheet with all this in it to make it easier for us to help you.

Hi flagonell. Welcome. Be sure to read through the Forum Rules so you can use and follow them effectively.

For instance, you'll need to post your questions into new threads of your own.
If you find this thread of possible interest, you can include a link to to it in your own thread.

New threads typically get the most attention anyway. Read over the rules real quick, then post your question and I'm sure you'll get a lot of rapid suggestions.

Hello jaichu,

The formula I suggested here was for a very specific scenario - could you please start your own thread and give an explanation of your requirements - which times you want to count, the possible start and end times (can they be outside the working hours?) and preferably a few examples - thanks