# Ref.info needed: =MOD, (findng Differce) [closed]

having (18:00) (21:06), =MOD((18:00)-(21:06), 1) = 7:06

Why? Thanks ... gripWIN@gmail.com

First time here? Check out the FAQ!

Ref.info needed: =MOD, (findng Differce) [closed]

having (18:00) (21:06), =MOD((18:00)-(21:06), 1) = 7:06

Why? Thanks ... gripWIN@gmail.com

close date 2017-12-10 17:13:50.854487

0

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.

0

*(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).

Asked: ** 2016-08-25 22:16:32 +0200 **

Seen: **22 times**

Last updated: **Aug 25 '16**

how can I save a spreadsheet with a chart on it? [closed]

why is find-and-replace grayed out [closed]

How do I set Libreoffice Default to open .CSV Files in Windows7 [closed]

How to convert to CSV with UTF-8 encoding using LO5 command line? [closed]

number forced to scientific notation [closed]

Get LibreOffice Version with macro

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Partly answered in https://ask.libreoffice.org/en/questi...