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

On 04/06/2016 09:36 AM, John Meyer wrote:
> 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 decimal time.  I need to take the last
> call of the day and add the decimal time to get an accurate shift
> time.    Do I just put the hh:mm:ss time in the time function and add
> that to the decimal time?
>
> Thanks.

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.  ;-)


-- 
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