Excel formula to calculate elapse days/hours/mins between two dates

[pinkyviolet08]

Hi! can you please help me on how to get the elapse days/hours/mins between two dates/time, excluding holidays and Saturday from 4:01am until Monday 04:59pm ?
Work shift:
starts : 5:00 pm
ends : 04:00 am

Thanks in advance

 

[padapinto]

=INT(E51-E49)&" days "&TEXT(E51-E49,"h"" hrs ""m"" mins """) roughly between 2 dates just like you have written but to extract if holidays and weekends, your data must be looking a bit different or arranged differently. if i may ask, is it timesheet you are dealing with?

 

[pinkyviolet08]

=INT(E51-E49)&" days "&TEXT(E51-E49,"h"" hrs ""m"" mins """) roughly between 2 dates just like you have written but to extract if holidays and weekends, your data must be looking a bit different or arranged differently. if i may ask, is it timesheet you are dealing with?

this is for project tracking.

 

[padapinto]

this is for project tracking.

you can try the formula i gave you but if you need timesheets tool, let me know.

 

[pinkyviolet08]

you can try the formula i gave you but if you need timesheets tool, let me know.

Thank you!!