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

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+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