Ask Your Question

Revision history [back]

click to hide/show revision 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 of0.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.

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

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.

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

Your =(val)/60 isn't a formula at all. You nee 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' 12 using h (hours) as the unit instead 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.

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.

errors.

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