Getting difference between working hours for given start/end date when time is not defined

[anuradhagrewal]

Hi
I need your help
I need to calculate the the total working hours between a start date and end date. This should also exclude holidays and weekends

For Eg:
Start date = 14-May-23
End date = 17-May-23
Now considering there are 4 working hours everyday available to a person to complete this task on a given day then how many working hours has he/she utilized to complete the task between the start and end date.
I have not mentioned the time as that can vary.

Can anybody tell me the formula for this in excel?

Thanks

Anu

 

[Anonymous1378]

Probably =NETWORKDAYS(start_date, end_date, [holidays])*4?