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

On 05-05-16 18:52, Bruce Hohl wrote:
Try this in cell A2 "=VALUE(A1)*24"

On Thu, May 5, 2016 at 12:44 PM, Russell <> wrote:

does anyone know if there is a formula for a cell that will transform the
HH:mm:ss from another cell into a decimal equivalent?


Cell A1 has 10:45:20

Cell A2 would change to 10.75


Cell A1 07:26:15

Cell A2 would change to 7.44 (or round it up 7.5)



see (for more info) point 4 of "[Tutorial] Ten concepts that every Calc user should know <>"
( )

4. Times in cells
A cell can contain a clock time, but the time is really stored as the corresponding fraction of a day. For example 6 AM is stored as 0.25 because it is ¼ of the way from midnight to midnight, but it is displayed as 6:00:00 AM. You can use Format → Cells → Numbers → Category → Time to display clock times in many formats, for example H:MM or HH:MM or HH:MM:SS, and any of these can have an optional AM/PM if you don't want to use 24-hour (military) time. A cell can contain both a date and a time. The value in the cell is the sum of the integer for the date and the fraction for the time. Format date/time cells by combining a date format and a clock time format. For cells which represent durations (difference of two clock times), the value could be more than one day, that is larger than 1, or even negative. The previously mentioned clock time formats display only the positive fraction; Calc adds or subtracts whole days until the time is between 00:00:00 and 23:59:59. To display a duration which exceeds 24 hours or is negative, you must enter the first part of the time format in brackets in the Format code field: [HH]:MM:SS or [HH]:MM or [HH] or [MM]:SS or [MM] or [SS]. There is no cell format which displays durations as days with hours/minutes/seconds. Be sure to remove the AM/PM format code from duration cells since they don't represent clock times, and always use one of the bracketed formats.

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.