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

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

Reply via email to