First time here? Check out the FAQ!

1 | initial version |

Your `=(val)/60`

isn't a formula at all. You nee 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.

**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.

2 | No.2 Revision |

Your `=(val)/60`

isn't a formula at all. You nee 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.

**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

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.

3 | No.3 Revision |

Your `=(val)/60`

isn't a formula at all. You nee 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.

**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.

4 | No.4 Revision |

Your `=(val)/60`

isn't a formula at all. You ~~nee ~~need to be much more precise about what you want to achieve.

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

using h (hours) as the unit instead ~~12' ~~12~~of0.5` ~~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.

5 | No.5 Revision |

Your `=(val)/60`

isn't a formula at all. You need to be much more precise about what you want to achieve.

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.

~~errors.~~

(Durations may exceed 24 h, of course. They are generally not handled correctly, however.)

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