Hours Calculation worked.

[coolhit]

Hi

I have a formula that works but trying to change it need help.

My current formula is

Please Login or Register  to view this content.

it calculates hours worked ie user enter 6:00 in g25 and 14:00 in h25 it will produce 8hr.

What i want to do is -0.5 to produce 7.5hr worked.

I did this by -0.5 in red below. it worked BUT when there is no hours it shows -0.5 i want it to show 0 only.

Please Login or Register  to view this content.

Can some help me.

[DonkeyOte]

Perhaps

=MAX(0,LOOKUP(10^10,CHOOSE({1,2},0,(24*MOD(H25-G25,1))-0.5)))