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: [email protected]
From: James <[email protected]>
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: [email protected]
> 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/
> Privacy Policy: https://www.documentfoundation.org/privacy
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:[email protected]
mailto:[email protected]
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: [email protected]
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/
Privacy Policy: https://www.documentfoundation.org/privacy
