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.930556Subtracting 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.