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

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:

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?


Spreadsheet dates are formatted numbers in unit "Days".
0.0 <==> 00:00
0.25 <==> 06:00 1/4 of a day
0.5 <==> 12:00 1/2 of a day
0.75 <==> 18:00 3/4 of a day
1.0 <==> 24:00 (with number format [HH]:MM)

There is no difference between the day fraction on the left and the
formatted number on the right. Both sides yield the exact same results
for all kinds of calculations and comparisons.
Multiply by 24 in order to convert days to hours and switch to some
decimal format when the result looks wrong.
Number format [HH]:MM displayes hours beyond 24 as full hours. This
number format should be used when you want to express time spans in
hours. A time span of 2 days and 3 hours (value 2.125) formatted as
HH:MM shows 03:00 (the hours at a point of time) whereas [HH]:MM shows

The first method actually calculates the amount of hours, the formatting
solution provides a more adequate representation of time spans without
any conversion.

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.