Rounding times in cell.v with milliseconds forget to report on minutes #2603

New Issue

2021-08-05T08:51:05Z

ekimv commented

2021-08-05 08:51:05 +00:00

(Migrated from github.com)

If you have an Excel with time data with milliseconds (eg 10:25:59.50) the cell.v is rounded but it does not affect the minute, neither the hour.
For example :
10:21:26.75 --> 10:21:27 ; OK
10:25:59.50 --> 10:25:00 ; KO ! the seconds are rounded to 00, but minutes should be increased by 1 to 10:26:00

If you have an Excel with time data with milliseconds (eg 10:25:59.50) the cell.v is rounded but it does not affect the minute, neither the hour. For example : 10:21:26.75 --> 10:21:27 ; OK 10:25:59.50 --> 10:25:00 ; KO ! the seconds are rounded to 00, but minutes should be increased by 1 to 10:26:00

martynfrank commented

2021-09-14 15:43:00 +00:00

(Migrated from github.com)

This issue appears to happen at the second level also. See example below:

This issue appears to happen at the second level also. See example below: ![image](https://user-images.githubusercontent.com/4399105/133289769-8ccbee4d-375a-4fea-bc34-3cdbfe4e1132.png)

Sign in to join this conversation.