Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenWed, 01 Mar 2017 01:18:29 +0100How to convert hh:mm:sec to DEC.?https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/ calc...mm:ss -> decimal ...
Using '=(val)/60 ... one problem; it does not Work!
WHERE'S MY MISTAKE?
Thanks!Tue, 28 Feb 2017 13:38:36 +0100https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/Comment by EasyTrieve for <p>calc...mm:ss -> decimal ...
Using '=(val)/60 ... one problem; it does not Work!</p>
<p>WHERE'S MY MISTAKE?</p>
<p>Thanks!</p>
https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?comment=88877#post-id-88877Time you will find is both simple and complex at the same time. There are many different representations for time and date, and many more useful functions for working with times and dates. Much too much material to be covered here without further confusing you. Rather, allow me to suggest you find the documentation on these and study it. I promise you will be rewarded, in short time. -- cheersWed, 01 Mar 2017 01:18:29 +0100https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?comment=88877#post-id-88877Answer by Lupp for <p>calc...mm:ss -> decimal ...
Using '=(val)/60 ... one problem; it does not Work!</p>
<p>WHERE'S MY MISTAKE?</p>
<p>Thanks!</p>
https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?answer=88824#post-id-88824Your `=(val)/60` isn't a formula at all. You need to be much more precise about what you want to achieve.
Just an info you may have missed:
Time-Of-Day values (if correctly created) are numerical values in the range from 0 (included) through 1 (excluded). By that they give the fraction of a day already elapsed. With different words: Calc (and spreadsheets in general) use the day as their implicit unit of time. (This has issues, of course, as everything as close to everyday life.)
If you tell us, you want to convert a time value to decimal, this contains a misunderstanding. You can **display** the time in a decimal format by simply changing the 'Numbers' format. If you want to get the numeric value using a different unit, you have to apply a conversion factor. To get `12` using h (hours) as the unit instead of `0.5` using d (days) e.g. you obviously need to multiply by 24. (`24 h = 1d`)
**If your "Time"** as present currently in your sheet **is actually text** in the hh:mm:ss format (or a reduced version starting with the hh part) you can apply the TIMEVALUE function first.
If the current representation of the time consists of three separate parts lik the hh part in A1, mm part in B1 and ss part in C1 you get the time by `=TIME(A1; B1; C1)`. Next comes the conversion factor as already mentioned.
Please note: Using different units for any kind of quantity in a spreadsheet requires some understanding of the underlying principles. Otherwise it is very likely to cause errors.
(Durations may exceed 24 h, of course. They are generally not handled correctly, however.)Tue, 28 Feb 2017 13:54:37 +0100https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?answer=88824#post-id-88824Answer by Mike Kaganski for <p>calc...mm:ss -> decimal ...
Using '=(val)/60 ... one problem; it does not Work!</p>
<p>WHERE'S MY MISTAKE?</p>
<p>Thanks!</p>
https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?answer=88822#post-id-88822Decimal what? minutes? nanoseconds?
Time in LO is actually a fraction of a day that is shown in time format. E.g., 12:00 pm is 0.5.
You may use something like this: `=SECOND(A1)/60+MINUTE(A1)+HOUR(A1)*60`Tue, 28 Feb 2017 13:44:23 +0100https://ask.libreoffice.org/en/question/88821/how-to-convert-hhmmsec-to-dec/?answer=88822#post-id-88822