Ask Your Question
0

What is my mistake? [closed]

asked 2016-08-30 13:27:12 +0200

abi gravatar image

updated 2017-12-10 17:06:50 +0200

erAck gravatar image

A1(23:34) B1(00:05) =MOD((B1-A1), 1) = 7:06 ? should be 00:31

Thanks for your time!

edit retag flag offensive reopen merge delete

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

Comments

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.

Kruno gravatar imageKruno ( 2016-08-30 18:50:57 +0200 )edit
erAck gravatar imageerAck ( 2017-12-10 17:11:54 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2016-08-30 14:02:51 +0200

updated 2016-08-30 14:04:38 +0200

The right code is:

=MOD((B1-A1);1)

If my answer helped you, vote it with ✔ and with ∧ (here on the left)

edit flag offensive delete link more
0

answered 2016-08-30 22:47:10 +0200

karolus gravatar image
=B1-A1+(B1<A1)
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2016-08-30 13:27:12 +0200

Seen: 75 times

Last updated: Aug 30 '16