Ask Your Question
0

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

asked 2016-08-25 22:16:32 +0100

abi gravatar image

updated 2017-12-10 17:12:21 +0100

erAck gravatar image

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

Why? Thanks ... gripWIN@gmail.com

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by erAck
close date 2017-12-10 17:13:50.854487

Comments

erAck gravatar imageerAck ( 2017-12-10 17:13:45 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2016-08-25 22:54:53 +0100

mark_t gravatar image

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.

edit flag offensive delete link more
0

answered 2016-08-25 22:46:57 +0100

floris v gravatar image

updated 2016-08-25 23:05:09 +0100

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

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-08-25 22:16:32 +0100

Seen: 22 times

Last updated: Aug 25 '16