12.07.2018 u 22:52, libreoffice-ml.mbou...@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+unsubscr...@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