Did the work below, but then came up with a simpler option.
Converts difference to minutes
=(E15-E14)/TIME(0,1,0)
Above Answer ANSWER/60
=((E15-E14)/TIME(0,1,0))/60
Above Answer INT(ANSWER/60) gives full hours
=INT(((E15-E14)/TIME(0,1,0))/60)
Above Answer MOD(ANSWR,60) gives minutes left
=MOD(((E15-E14)/TIME(0,1,0)),60)
Original way of doing it.
E14 = 04/23/15 03:30 PM
E15 = 04/25/15 04:20 PM
E16 = 48
E17 = 50
E18 = 0
E19 = 50
E20 = 48
E21 = 48.833333
Formula in E16 to calc Hours in full days
=int(e15-e14)*24
Calculates the number of minuts left
E17 = =MOD((E15-E14),1)/TIME(0,1,0)
Calculate number of Hours in partial day
E18 = =INT(E17/60)
Calc Remain Minutes
E19 = =MOD(E17,60)
Calc Total Hours
E20 = =E16+E18
Calc Hours with fraction.
E21 = =E20+E19/60
Added 12 hours to test results.
04/23/15 03:30 PM
04/26/15 04:20 AM
48
Full Hours
770
Extra
Minutes
12
Hours
50
Minutes
60
Total
Hours
60.8333333333
On 24 Apr 2015 at 1:46, sserra wrote:
Date sent: Fri, 24 Apr 2015 01:46:12 -0700 (MST)
From: sserra <[email protected]>
To: [email protected]
Subject: [libreoffice-users] time and date difference
> hello everyone,
> I am using LibreOffice Version: 4.3.0.4 and I am having issues calculating
> time differences..
>
> I would like to calculate the time difference in hours between the following
> date/times:
>
> E14 = 23/04/2015 15:30
> E15 = 25/04/2015 16:20
> E16 = DAYS(E15;E14)
>
> But I get a value error so I split data:
>
> F14 = 23/04/2015
> F15 = 25/04/2015
> F16 = DAYS(F15;F14) ---> Ok, I get 2, multiply x 24 = 48h and it's fine
>
> then for the hours
>
> G14 = 15:30
> G15 = 16:20
> G16 = (G15<G14)+G15-G16 (as suggested by the wiki:
> https://help.libreoffice.org/Calc/Calculating_Time_Differences)
>
> but again I have a value error..
>
> does anyone knows how can I solve this??
>
>
>
> --
> View this message in context:
> http://nabble.documentfoundation.org/time-and-date-difference-tp4147099.html
> Sent from the Users mailing list archive at Nabble.com.
>
> --
> To unsubscribe e-mail to: [email protected]
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>
+----------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor
Guam Community College Computer Center
mailto:[email protected]
mailto:[email protected]
http://www.guam.net/home/mikes
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 28512493.011262 | SETI 50011275.211265
ABC 16613838.513356 | EINSTEIN 58725353.615700
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
