# 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: **25 times**

Last updated: **Aug 25 '16**

Copying data from a Calc spreadsheet to a Base table

Help with VLOOKUP Formula [closed]

LibreOffice Calc (Not Responding)

Duplicate entire sheet? [closed]

Need to insert cell data into a text box [closed]

Is there a way to get a subrange from a given range, specifically a named range?

Remove commas from decimal number?

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...