2015 Archives by date, by thread · List index

# Re: [libreoffice-users] time and date difference

Did the work below, but then came up with a simpler option.

Converts difference to minutes
=(E15-E14)/TIME(0,1,0)

=((E15-E14)/TIME(0,1,0))/60

=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 <simone.serra@cogne.com>
To:                     users@global.libreoffice.org
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: users+unsubscribe@global.libreoffice.org
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:mikes@kuentos.guam.net
mailto:msetzerii@gmail.com
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: users+unsubscribe@global.libreoffice.org
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