• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to get the number of hour between 2 date and time

BharathBabu

New Member
Hello All,

I just wanted to know the formula for the below query.

Start dates:
02/17/2023 09:15:26
02/23/2023 15:15:00
02/23/2023 14:20:25

End date:
02/24/2023 16:10:23
02/23/2023 16:30:02
02/24/2023 10:25:03

Results will be : No of hours taken between start date and end date (sample answer 10:02:30)

Condition:
1. It should not consider weekend dates and non working hours
2. Per day 8 hours working


Appreciate your quick response!

Thanks in advance
Bharath
 
Last edited:
We can do something like this in column C with MS365:
83142

This is a LAMBDA named formula used like:

83143

You get a hint as to what the arguments should refer to, with optional weekend and holiday arguments, whose values should be be as in the NETWORKDAYS.INTL function.
I've guessed a workday starting at 9am and finishing at 5pm, but we need to know this.

I'll await a workbook from the OP.
 
Last edited:
Please find the attached excel.
Highlighted in the colour is the sample output. Expecting final out with hours, minutes, seconds.
I need formula to derive. Excluding Weekends, Per day working hours is 8hours. It should calculate only weekdays

Please do the needful. on quick assistance
 

Attachments

  • QUery.xlsx
    32.4 KB · Views: 6
Working Hours is 8hours. Time from 8am to 17pm. Excluding weekends
Same day request completed also be captured
 
Last edited:
Back
Top