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

12.07.2018 u 22:52, libreoffice-ml.mbourne@spamgourmet.com je napisao/la:
> Krunose wrote:
> > 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?
>
> Assuming those dates are 7th January 2018, since your mail headers 
> indicate you're using a US locale...
>
> 2018-01-07 15:30:00 is represented internally as 43107.645833
> 2018-01-07 22:20:00 is represented internally as 43107.930556
>
> Subtracting those numbers gives 0.284723, which represents the 
> date/time 1899-12-30 06:50:00
>
> The day of month is 30, hence the 30 when that value is represented as 
> d:h:m.


Ah, I get it -- and I don't. If I want 0.284723 to be represented as 
'd-h-m', why to treat it as date? Wouldn't it make sense to include a 
function to LO Calc that could convert that number in desired format in, 
just guessing, a text type.

So something like =TIMEPASSED(A1;"d:m:s:ms") or 
=TIMEPASSED(A1;"YEARS-MONTHS-DAYS-HOURS-MINUTES-SECONDS") to get 
0-0-0-6-50-0?

Seams not very complicated to add function like that...

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