Interesting how people think differently.
Assuming dates have cell format date and time has cell format time;
I came up with days first = (A2+B2)-(A1+B1) (cell format general)
hours = days*24 (cell format general)
steve
On 25/05/18 10:05, Michael D. Setzer II wrote:
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
