Ask Your Question

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

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

abi gravatar image

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

oweng gravatar image

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

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

karolus gravatar image


= Q123 - TIME(2;30;0)


edit flag offensive delete link more

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

reddish gravatar image

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

edit flag offensive delete link more

Question Tools

1 follower


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

Seen: 188 times

Last updated: Aug 18 '14