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.
--
Mark.
--
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