Count Hours between 2 dates

See if the following formula works for you:

=MAX(0,21/24-MOD(A1,1))+MAX(0,MOD(B1,1)-9/24)+(INT(B1)-INT(A1)-1)/2

Or try:

=DATEDIF(A1,B1,"d")/2+MEDIAN(MOD(B1,1),9/24,21/24)-MEDIAN(MOD(A1,1),9/24,21/24)

Originally Posted by Root_

See if the following formula works for you:

=MAX(0,21/24-MOD(A1,1))+MAX(0,MOD(B1,1)-9/24)+(INT(B1)-INT(A1)-1)/2

Hello,
Thank you for your time helping me.
The formula seem to have a error, on a ).

Thanks anyway.

Originally Posted by Phuocam

Or try:

=DATEDIF(A1,B1,"d")/2+MEDIAN(MOD(B1,1),9/24,21/24)-MEDIAN(MOD(A1,1),9/24,21/24)

Hello,

First i was having trouble because datedif was not showing, but after some research found that I can still use it.

Thanks, this solved my issue.