Haz tu Pregunta

perfil de ObrienDave - actividad

2015-11-04 12:46:44 +0200 recibió una medalla  Buena Respuesta (fuente)
2015-03-24 03:41:25 +0200 recibió una medalla  Patrulla Ciudadana (fuente)
2014-10-31 11:11:07 +0200 comentar respuesta Time formats in Calc suitable for use in calculations

Can you paste a small amout of your data in a spreadsheet, please?

I have an idea.

2014-10-31 07:30:35 +0200 recibió una medalla  Profesor (fuente)
2014-10-31 04:07:59 +0200 respondió a una pregunta How do I have calc create a sequence of numbers down a column in 1/8 inch increments? (Ex. 1/8, 1/4, 3/8, 1/2, 5/8, 3/4, 7/8, 1, 1 1/8...)

format cells using the fraction format

a1 = .125

a2 = a1 +.125

copy as needed to subsequent cells

2014-10-30 06:25:51 +0200 respondió a una pregunta Time formats in Calc suitable for use in calculations

LibreOffice, OpenOffice, Excel, etc., do NOT calculate times as hours, minutes, and seconds.

You have to convert them to fractions of a day or use the format string for elapsed time.

So, your 1:10:36 works out to 0.0490277777777778 days.

Your 58:20 is 0.0405092592592593 days.

For example, running 5 miles in 00:58:20 should be 5/0.0405092592592593/24 to give you 5.1428571429 miles per hour

Add /24 at the end of your formula