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