0

Why does subtracting a time from a cell return Err:502? [closed]

asked 2014-08-13 19:11:35 +0100

abi
31 ●50 ●91 ●117

updated 2014-08-18 06:12:43 +0100

flag of Australia

23253 ●20 ●98 ●167

Given cell Q123 is formatted to display a time as 13:37 entering =Q123-2:30 in another cell results in Err:502. Why?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-02 12:23:42.418623

2 Answers

Sort by » oldest newest most voted

2

answered 2014-08-13 21:27:59 +0100

flag of Germany

5534 ●17 ●40

Hallo

= Q123 - TIME(2;30;0)

Karolus

edit flag offensive delete link

0

answered 2014-08-13 19:55:17 +0100

51 ●1 ●2

It seems to me that the colon does not make sense there.

edit flag offensive delete link

Question Tools

1 follower

Stats

Asked: 2014-08-13 19:11:35 +0100

Seen: 188 times

Last updated: Aug 18 '14

Related questions

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

Powered by Askbot version 0.9.3