DV-0028
ironcalc: different error code — HOUR, MINUTE, SECOND
Subjects (3)
Tests (6)
matches canonical diverges no fixture in this DV's cluster
| Test | Formula | Canonical | gsheets | excel | lattice | ironcalc | hyperformula | libreoffice | formulas | pycel |
|---|---|---|---|---|---|---|---|---|---|---|
HOUR/hour-from-string |
=HOUR("13:30:45") |
13 | gsheets13 | excel13 | lattice13 | ironcalc#VALUE! | hyperformula13 | libreoffice— | formulas13 | pycel13 |
HOUR/hour-midnight |
=HOUR("00:00:00") |
0 | gsheets0 | excel0 | lattice0 | ironcalc#VALUE! | hyperformula0 | libreoffice— | formulas0 | pycel0 |
MINUTE/minute-basic |
=MINUTE("13:30:45") |
30 | gsheets30 | excel30 | lattice30 | ironcalc#VALUE! | hyperformula30 | libreoffice— | formulas30 | pycel30 |
MINUTE/minute-zero |
=MINUTE("13:00:00") |
0 | gsheets0 | excel0 | lattice0 | ironcalc#VALUE! | hyperformula0 | libreoffice— | formulas0 | pycel0 |
SECOND/second-basic |
=SECOND("13:30:45") |
45 | gsheets45 | excel45 | lattice45 | ironcalc#VALUE! | hyperformula45 | libreoffice— | formulas45 | pycel45 |
SECOND/second-zero |
=SECOND("13:30:00") |
0 | gsheets0 | excel0 | lattice0 | ironcalc#VALUE! | hyperformula0 | libreoffice— | formulas0 | pycel0 |