Ask Your Question

Where is info on Err: 102?

asked 2019-06-22 17:21:56 +0200

abi gravatar image

I am trying to MULTIPLY - :15 sec * 10. =product((0:15)*10). Os the structure correct?

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-06-24 12:34:38 +0200

erAck gravatar image

There is no Err:102, probably you mean Err:502, for which see ebot's, answer. However, your error is the 0:15 part, you can't enter times like this in a formula expression, use TIME(0;0;15) instead. Also you don't need the PRODUCT() function for one argument, specifically you already did the multiplication with the * operator. Your formula should be =TIME(0;0;15)*10

edit flag offensive delete link more

answered 2019-06-22 21:38:19 +0200

ebot gravatar image

Have a look on this side.

edit flag offensive delete link more

answered 2019-06-24 13:21:47 +0200

Lupp gravatar image

To get something like 0:15 interpreted as a duration at all, it must be text. Then you can apply the function TIMEVALUE() to it. The part in front of the first colon, however, is always taken for the number of hours then, and there is no way to change that by any attributes. Meaning 15 s , you need to write 0:0:15 as text therefore, or better 0:00:15.
Dont start to play it this way if avoidable at all. The colon-notation is specified for TOD (TimeOfDay). Durations should be given in actual units like 3 h 21 min 33 s. Unfortunately spreadsheets neither supply functions to accept this format for conversion to a numeric standard representation, nor support they a respective number format by default, nor is a conversion of duration values given in the frequently misused colon-format to a correct duration format supported.
If you actually have texts giving durations in a correct format, and you need to calculate with them, this might be a case where using a custom function is justified. For LibO V 6.2 or higher there also is an acceptable solution with standard functions. (Thanks to @erAck.)
You may take a glance into this little demo.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-22 17:21:56 +0200

Seen: 60 times

Last updated: Jun 24 '19