2018 Archives by date, by thread · List index

# Re: [libreoffice-users] difference in hours between two times

```Divide the difference by an hour, and you get the hours, and then divide that
by 24 or could do the same and divide by 24 hours.

05/16/18        08:30:00 PM        111.58                                               4.65
05/21/18        12:05:00 PM        '=((A2+B2)-(A1+B1))/TIME(1,0,0)      '=C1/24

On 24 May 2018 at 15:07, James wrote:

To:                     users@global.libreoffice.org
From:                   James <bjlockie@lockie.ca>
Subject:                [libreoffice-users] difference in hours between two
times
Date sent:              Thu, 24 May 2018 15:07:15 -0400

```
```I have a calc spreadsheet with column A being a date and column B is a time.
I am trying to make a foruma that calculates the difference in days and
another for the difference in hours between 2 rows.

For example:
column A
Wed, May 16, 2018
Mon, May 21, 2018

column B
08:30 PM
12:05 PM

column C
=((A13+B13)-(A12+B12))
=((A14+B14)-(A13+B13))[4.65]

column D
=TRUNC(C13)
=TRUNC(C14) [4]

column E
-
formula? [.65]

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
```
```

+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mikes@guam.net
mailto:msetzerii@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS

ROSETTA      65540984.279607 | ABC          16613838.513356
SETI        109371053.691072 | EINSTEIN    141058465.999240

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/