[Libreoffice-bugs] [Bug 133919] Import of Excel format data transfer file rounds time incorrectly

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133919

--- Comment #2 from Steve Garry <info at huntsgrove.ie> ---
Created attachment 161904
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161904&action=edit
screenshot of opened data file

All times shown with minute of (eg) 59 are rounded incorrectly, and should be
rounded up to the next minute, which then gives the value that has been used in
the calculation of elapsed time. In line 1 for example, the actual stored start
time is 5:00 pm. as sebnt, no formatting has been applied to the data, it is as
sent by android and imported into Calc. Changing the formatting of the cells
does not remove the error

lines 1, 2, 5, 7, 8, 9, 13, 16, 17, 21, 22, 23, 24, 27, 30, 32, 33, 34,35, 36,
37, 38, 43 and 44 all show examples of this error on either the start or finish
time.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200612/4155b5e8/attachment.htm>