Formula to count days between 2 dates/times excluding weekends but including only partial days depending on when the date/time falls (see description)

[freeb1893]

I’d to take 2 date/times and calculate the time between them

I’d like to exclude counting weekends

I’d like to count partial days based on a custom start time and custom end time that I define in reference cells, and it’s what is considered 1 day

For example, I’d like to set my start time of a day in cell G1, and my end time of a day in cell H1. In G1 I set my start time of a day as 8:00AM, in H1 I set my end time of a day as 5:00PM

For my start dates, I want to count 1 full day as 8:00AM to 5:00PM that day (defined and adjustable in my reference cells of G1 and H1). If the start time happens to be 7:00AM, I still only count time from 8:00AM through 5:00PM that day. If the start time happens to be after 5:00PM, I don’t want to count any time for that day in my result. Same logic for my end dates. If the end time is before my 8:00AM reference in cell G1, I don’t want to count any time on my end date. If my end time is after 5:00PM, I only want to count time between 8:00AM to 5:00PM as defined in my reference cells as 1.00 days.

I also may have 2 dates/times that don’t have weekends between them. I also may have 2 dates/times that have multiple weekends between them that I don’t want to count in my day/time result. I also may have 2 dates/times that are just a matter of minutes or hours within a single day.

Anyone know how to put this into a formula? Thanks in advance

 

[Peter_SSs]

Is this a repeat/continuation of this thread? Take date/time and calculate the time in between excluding weekends and including partial days

 

[Peter_SSs]

Please continue in the thread linked above. This one closed.