Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

On 04/06/2016 09:36 AM, John Meyer wrote:

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?


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 &

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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.