What is my mistake?

[abi]

A1(23:34) B1(00:05) =MOD((B1-A1), 1) = 7:06 ? should be 00:31

Thanks for your time!

[Kruno]

See MOD function on Help page. Could you edit title of this question to be more descriptiv. Nobody can guess what is question all about from it. When you find answer you like - mark it as correct.

[erAck]

Duplicate of Ref.info needed: =MOD, (findng Differce)

[charlie.it]

The right code is:

=MOD((B1-A1);1)

If my answer helped you, vote it with and with ∧ (here on the left)

[karolus]

=B1-A1+(B1<A1)