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

2016-05-06 Thread John Meyer
So if I'm getting this right, I would just do something like this: A B 1 Last Call: 5:58:16 2 Duration: 6.24 Total:: =B1 + B2 (and format as needed) On 4/6/2016 8:07 AM, Andreas Säger wrote: Am 06.04.2016 um 15:36 schrieb John Meyer: Hi, I have a project

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

2016-04-07 Thread Andreas Säger
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

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

2016-04-06 Thread Andreas Säger
Am 06.04.2016 um 15:36 schrieb John Meyer: > Hi, > > I have a project where I am trying to calculate the total amount of work > hours for a project based upon the timestamp of calls throughout the > day. The time at which the calls is placed is in hh:mm:ss while the > duration of the call is in