Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Time formats in Calc suitable for use in calculations

Hello.

I have a spreadsheet into which I am importing time values. These are elapsed times for walking/running activities. They appear in the spreadsheet as 1:10:36 (hours-mins-secs) or 58:20 (min-secs).

In this format I can't use them in calculations for working out average speed and/or average pace. The calculations happen but give wildly incorrect results.

Is there a suitable format available that will convert these to decimal hours that I can use in calculations? If not can anyone suggest a formula I could used to do the conversion?

Thanks in advance.

Time formats in Calc suitable for use in calculations

Hello.

I have a spreadsheet into which I am importing time values. These are elapsed times for walking/running activities. They appear in the spreadsheet as 1:10:36 (hours-mins-secs) or 58:20 (min-secs).

In this format I can't use them in calculations for working out average speed and/or average pace. The calculations happen but give wildly incorrect results.

Is there a suitable format available that will convert these to decimal hours that I can use in calculations? If not can anyone suggest a formula I could used use to do the conversion?

Thanks in advance.

Time formats in Calc suitable for use in calculations

Hello.

I have a spreadsheet into which I am importing time values. These are elapsed times for walking/running activities. They appear in the spreadsheet as 1:10:36 (hours-mins-secs) or 58:20 (min-secs).

In this format I can't use them in calculations for working out average speed and/or average pace. The calculations happen but give wildly incorrect results.

Is there a suitable format available that will convert these to decimal hours that I can use in calculations? If not can anyone suggest a formula I could use to do the conversion?

Thanks in advance.