Time Difference Wrong with "Custom" Cell Format

10:15 - 09:15 = 00:59 when I use cell format “[HH]:mm” for the cell that does the calculation (=A1-B1).
When I use “HH:mm” it is 01:00, correct.
The “[” and “]” are for not limiting it to 24h. Seems like a bug to me.

BR Matthias

Hello

I cannot confirm your observation - My version (LO 6.2.1.2 / Linux ) shows the following result

End	 Start	Diff	   Format
10:15	09:15	01:00	HH:MM
10:15	09:15	01:00	[HH]:MM

May be you provide a anonymized testfile showing your result

6.2.0 tdf#122991 fixed in 6.2.1

Thanks. I’m on 6.2.0.3