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: [email protected] 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
