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