Hours worked.

[gleemonex69]

Good morning everyone. I have another questions. I'm currently using this calculation:

=(I6+IF(OR(I6=0,I6<H6),1,0)-H6)*24

to calculate total hours worked where H6 is In time and I6 is Out time. Thing is, it displays a "24" if there are no hours worked for that day. What would be the correct formula to show total hours worked, but display "0" if no hours are worked? Thank you all in advance.

 

[barry houdini]

Hello gleemonex69,

Your formula got truncated, probably because you have < or > signs within it. Try posting it again but put spaces either side of < or >

 

[gleemonex69]

=(I6+IF(OR(I6=0,I6 < H6),1,0)-H6)*24

sorry about that.

 

[barry houdini]

How about this version?

=MOD(I6-H6,1)*24