2016 Archives by date, by thread · List index

# [libreoffice-users] Re: Adding decimal minutes to regular minutes and hours (calc)

```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+unsubscribe@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
```