A1(23:34) B1(00:05) =MOD((B1-A1), 1) = 7:06 ? should be 00:31
Thanks for your time!
A1(23:34) B1(00:05) =MOD((B1-A1), 1) = 7:06 ? should be 00:31
Thanks for your time!
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.
The right code is:
=MOD((B1-A1);1)
If my answer helped you, vote it with and with ∧ (here on the left)
=B1-A1+(B1<A1)