# How to convert hh:mm:sec to DEC.?

calc...mm:ss -> decimal ... Using '=(val)/60 ... one problem; it does not Work!

WHERE'S MY MISTAKE?

Thanks!

First time here? Check out the FAQ!

How to convert hh:mm:sec to DEC.?

calc...mm:ss -> decimal ... Using '=(val)/60 ... one problem; it does not Work!

WHERE'S MY MISTAKE?

Thanks!

0

Your `=(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.)

0

Decimal 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`

Asked: ** 2017-02-28 13:38:36 +0100 **

Seen: **2,344 times**

Last updated: **Feb 28 '17**

Conditionally change data range of a chart in CALC? [closed]

Unable to open files from windows share [closed]

Concatenation of multiple cells on multiple rows

Sum of cells that contain math formula

HowIF find AVGIF, "x=0"; when ERR 'DIV/O'?

find/replace: if keyword found inside cell, overwrite complete cell with new keyword

Protecting a Cell Disables Users to Adjust the Width/Height?

How to get a list of all unique values from two columns? [closed]

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

Time 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. -- cheers