https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #18 from Eike Rathke <er...@redhat.com> --- (In reply to Nenad Antic from comment #16) > > You'll also notice that most of your results will be unexpected because > > starting at row 14 date+time in column D and E are of different days and the > > result is a duration of 33 hours instead of 9 hours. > > This is strange. I have used it like this for years and it works. Please see > my new attachment. If it's showing 33 hours at your end it seems like it's > platform dependent. No. It works in your document because using only HOUR() and MINUTE() of the difference ignores the date part. The time span between (E14) 2022-07-07 07:00:00 and (F14) 2022-07-08 16:00:00 is certainly not 9 hours but 33. Which becomes visible when using my formula to calculate. If the 9 hours is expected then the data is not correct (which in this case is likely). -- You are receiving this mail because: You are the assignee for the bug.
