Ask Your Question
0

Time Difference Wrong with "Custom" Cell Format [closed]

asked 2019-03-06 10:47:28 +0200

matthias gravatar image

updated 2019-03-06 10:48:11 +0200

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-03-06 19:51:43.675200

Comments

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

Opaque gravatar imageOpaque ( 2019-03-06 14:17:44 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2019-03-06 14:28:37 +0200

erAck gravatar image

6.2.0 tdf#122991 fixed in 6.2.1

edit flag offensive delete link more

Comments

Thanks. I'm on 6.2.0.3

matthias gravatar imagematthias ( 2019-03-06 16:54:35 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2019-03-06 10:47:28 +0200

Seen: 27 times

Last updated: Mar 06