search

tgrosinger / advanced-tables-obsidian

Improved table navigation, formatting, and manipulation in Obsidian.md
GNU General Public License v3.0
2.14k stars 80 forks source link

Overflow bug when using durations #344

Open handarel opened 2 weeks ago

handarel commented 2 weeks ago

When formatting a number with ;hm and it results in a value above 99:59, it overflows. The following tables can be used to reproduce the bug:

| Start Date       | End Date         | Duration (Expected) | Duration (Actual) |
| ---------------- | ---------------- | -------------------:| -----------------:|
| 2024-11-01 08:00 | 2024-11-05 14:00 |              102:00 |             02:00 |
<!-- TBLFM: $>=($2-$1);hm -->
| Date                | Start Time | End Time | Duration (Expected) | Duration (Actual) |
| ------------------- | ----------:| --------:| -------------------:| -----------------:|
| 2024-11-01          |      01:00 |    23:00 |               22:00 |             22:00 |
| 2024-11-02          |      01:00 |    23:00 |               22:00 |             22:00 |
| 2024-11-03          |      01:00 |    23:00 |               22:00 |             22:00 |
| 2024-11-04          |      01:00 |    23:00 |               22:00 |             22:00 |
| 2024-11-05          |      01:00 |    23:00 |               22:00 |             22:00 |
| **Total Duration:** |            |          |              110:00 |             10:00 |
<!-- TBLFM: $>=($3-$2);hm -->
<!-- TBLFM: @>$>=sum(@2$>..@-1$>);hm -->

OS: Windows 11 Obsidian Version: 1.7.4 Advanced Tables Version: 0.22.1