Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

Am 06.04.2016 um 19:27 schrieb James Knott:

While I haven't done this in a spreadsheet, I used to on a calculator. 
I did it by converting between decimal degrees and degrees, minutes &

BTW, as an indication of how long ago I did this, I used this method to
add up the time for tracks on an LP to figure out how much time I'd need
on a cassette.  ;-)

You could have used a spreadsheet back in the 80ies and it would be the
exact same method. Either multiply the days by 24 to get hours or change
the number format. As a third method you may separate full days from day

A1: =PI()
=int(A1) => 3 full days
=mod(A1;1) => 3:24 (about 1/7 of a day)

A1 formatted as HH:MM => 03:23 (time on day #3)
A1 formatted as [HH]:MM => 75:24 (showing full hours)
=A1*24 => 75.4 hours

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.