Snasui Excel Forum

Hi Dear
I need your help to calculate total leave day.
Business day from Mon-Friday
07:00 am to 17:00 pm
For example
Date From:04/05/20
Date To:04/05/20
Time From:8:00
Time To:17:00
So Total leave would be 1 Day
Date From:21/05/20
Date To:22/05/20
Time From:13:00
Time To:17:00
So Total leave would be 1.5 Days
...
How can we write formula in excel to do that?

Best wishes,

Here is a sample file

How about this,

H2

=FLOOR(((G2-F2)*24),2)/8

Press enter and copy down.

Hi Dear
Thank you so much
I just add this
=E2-D2+FLOOR(((G2-F2)*24),2)/8
It is working

Best wishes