having (18:00) (21:06),
=MOD((18:00)-(21:06), 1) = 7:06
Why?
Thanks …
<edit: removed email-address to prevent spam to OP>
having (18:00) (21:06),
=MOD((18:00)-(21:06), 1) = 7:06
Why?
Thanks …
<edit: removed email-address to prevent spam to OP>
Your formula gives error 508 (for , instead of ; and 502 for the syntax error).
Enter those times in two cells A1 and B1, then the formula =MOD(B1-A1;1)*24 yields 3.1 for me (Libre 5.2, Windows 10).
Your formula “=MOD((18:00)-(21:06),1)” gives an Err:502.
Assuming you are trying to calculate using cells that contain times in this format you should note that Time format is based on 1 = 24 hours.
(18:00)-(21:06) = -0.129166666666667,
Then Mod(-0.129166666666667,1) = 0.870833333333333,
in time format is 20:54:00
If you describe what you want to calculate we might be able to suggest a better method.