If start date and end date is less than 24hrs. Then how to calculate Total_working_hours_excluding_weekends

Formula I applied: =IF(C3-B3<TIMEVALUE(“24:00:00”),E3,NETWORKDAYS($B3,$C3)-1-MOD($B3,1)+MOD($C3,1))

But its not working. Please help me out.

start date

07-07-2017 11:15:20

end date

08-07-2017 00:59:20

By: Bhaskar

Leave a Reply

Your email address will not be published. Required fields are marked *