[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Fwd: [libreoffice-users] record durations, not time of day


I realise that I accidentally (and yet again) sent my answer directly to
the original poster. Sorry for that. Here it is, even though the question
has already been answered:

---------- Forwarded message ---------
Från: Johnny Rosenberg <gurus.knugum@gmail.com>
Date: tors 1 aug. 2019 kl 01:30
Subject: Re: [libreoffice-users] record durations, not time of day
To: Eric Beversluis <ebever@researchintegration.org>


Den tors 1 aug. 2019 kl 00:46 skrev Eric Beversluis <
ebever@researchintegration.org>:

> I want to enter numbers in Calc like 3:05 that stands for 3 minutes and 5
> seconds (duration), not for some time of day. How do I do this?
>

You do just that. For 3 minutes 5 seconds, enter 0:3:5 (or 0:03:05). the
cell value will then be (3·60+5)/86400, which is your time in days, but you
format it as MM:SS and your cell will display 03:05, or M:SS for 3:05.
If you add times and you don't want to use hours, then format as [MM]:SS.
That will give you, for instance, 65:37 for 1 hour, 5 minutes and 37
seconds.
So it's basically all about formatting. The actual value in the cell is
still in days as a floating point number (for instance 0.125=4 hours=240
minutes).

It's important to input hours even if you don't use them, otherwise your
input will be interpreted as HH:MM rather than MM:SS.


Kind regards

Johnny Rosenberg


>
> Eric Beversluis
> Short fiction at www.ericbeversluis.com
>
>
> --
> To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

References:
[libreoffice-users] record durations, not time of dayEric Beversluis <ebever@researchintegration.org>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.