Re: [libreoffice-users] Calculate difference between two dates (with time)

12.07.2018 u 16:36, Michael D. Setzer II je napisao/la:
> 01/17/18 03:30 PM         01/17/18 03:30 PM
> 01/17/18 10:20 PM         01/17/18 10:20 PM
> 0:6:50:0                  0:06:50:00
> Formula in A3
> "=TEXT(INT(A2-A1),"#0")&":"&TEXT(((A2-A1)-INT(A2-A1)),"H:M:S")

Nice! Thanks!

But makes me wonder what's wrong with

       =TEXT((A2-A1);"d:h:m")

as it works well in Excel. Maybe I should file a feature request?

Kruno


> Formula in B3
> "=TEXT(INT(A2-A1),"#0")&":"&TEXT(((A2-A1)-INT(A2-A1)),"HH:MM:SS")    
>
> I did include seconds, but you could remove the :S, and have options to
> show 2 digits or just one. The #0 makes it print the 0, but ## would print
> blank for zero values.
>
>
> On 12 Jul 2018 at 13:42, Krunose wrote:
>
> To:                     users@global.libreoffice.org
> From:                   Krunose <kruno.se@gmx.com>
> Subject:                [libreoffice-users] Calculate difference between
> two dates (with time)
> Date sent:              Thu, 12 Jul 2018 13:42:36 +0200
>
> > Hi,
> >
> > just a quick question: if A1 holds 1.7.18. 15:30 and if A2 holds 1.7.18.
> > 22:20, why then
> >
> >             =TEXT((A2-A1);"d:h:m")
> >
> > returns 30:6:50 instead 0:6:50?
> >
> >
> > Thanks,
> >
> > Kruno
> >
> >
> > --
> > 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/
> > Privacy Policy: https://www.documentfoundation.org/privacy
>
> +------------------------------------------------------------+
>   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      65602903.467560 | ABC          16613838.513356
> SETI        109419383.050719 | EINSTEIN    141198856.499240


--
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/
Privacy Policy: https://www.documentfoundation.org/privacy