https://bugs.documentfoundation.org/show_bug.cgi?id=136615
--- Comment #16 from Nenad Antic <[email protected]> --- (In reply to Eike Rathke from comment #15) > simply use > > =IF(AND(ISBLANK(D11),ISBLANK(E11)),"",ROUND((E11-D11)*24,2)) > > to subtract start from end date+time and express the difference as hours of > duration. Thank you for this tip. I'll try it. > > 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. -- You are receiving this mail because: You are the assignee for the bug.
