Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 03 Mar 2017 13:28:58 +0100Hours intervalhttps://ask.libreoffice.org/en/question/88858/hours-interval/ Looking for a formula that will calculate the number of hours when the start time and end time span more than 24 hoursTue, 28 Feb 2017 21:28:38 +0100https://ask.libreoffice.org/en/question/88858/hours-interval/Answer by Mike Kaganski for <p>Looking for a formula that will calculate the number of hours when the start time and end time span more than 24 hours</p>
https://ask.libreoffice.org/en/question/88858/hours-interval/?answer=88892#post-id-88892You may use TEXT(<ref>, "[HH]") to get the string with requested value.
If you need a number, you may multiply your datetime value by 24, and have a float with whole part as number of hours, and fractional part as fraction of an hour (rationale: datetime is a floating-point value that represents time as number of **days**). Formatting the result as Number (opposed to Time) will give you result in convenient form.Wed, 01 Mar 2017 05:34:23 +0100https://ask.libreoffice.org/en/question/88858/hours-interval/?answer=88892#post-id-88892Comment by nickd006 for <p>You may use TEXT(<ref>, "[HH]") to get the string with requested value.
If you need a number, you may multiply your datetime value by 24, and have a float with whole part as number of hours, and fractional part as fraction of an hour (rationale: datetime is a floating-point value that represents time as number of <strong>days</strong>). Formatting the result as Number (opposed to Time) will give you result in convenient form.</p>
https://ask.libreoffice.org/en/question/88858/hours-interval/?comment=89151#post-id-89151Thanks. I will try thatFri, 03 Mar 2017 13:28:58 +0100https://ask.libreoffice.org/en/question/88858/hours-interval/?comment=89151#post-id-89151