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 & > seconds. > > 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 fractions. 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: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
