diff options
| author | xuri <xuri.me@gmail.com> | 2021-11-12 01:01:50 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-11-12 01:01:50 +0800 |
| commit | 5de671f8bb8a4d8951d5511c3bd1745fc46ce842 (patch) | |
| tree | 43e7b5b75bf3accf1cc70c61294adb1196e36043 /calc_test.go | |
| parent | 00eece4f53f034a8dff009330ca45f1012e64ee3 (diff) | |
ref #65: new formula function MINUTE
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6420715..90138a1 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1105,6 +1105,12 @@ func TestCalcCellValue(t *testing.T) { "=ISOWEEKNUM(\"42370\")": "53", "=ISOWEEKNUM(\"01/01/2005\")": "53", "=ISOWEEKNUM(\"02/02/2005\")": "5", + // MINUTE + "=MINUTE(1)": "0", + "=MINUTE(0.04)": "57", + "=MINUTE(\"0.04\")": "57", + "=MINUTE(\"13:35:55\")": "35", + "=MINUTE(\"12/09/2015 08:55\")": "55", // MONTH "=MONTH(42171)": "6", "=MONTH(\"31-May-2015\")": "5", @@ -2438,6 +2444,11 @@ func TestCalcCellValue(t *testing.T) { "=ISOWEEKNUM(\"\")": "#VALUE!", "=ISOWEEKNUM(\"January 25, 100\")": "#VALUE!", "=ISOWEEKNUM(-1)": "#NUM!", + // MINUTE + "=MINUTE()": "MINUTE requires exactly 1 argument", + "=MINUTE(-1)": "MINUTE only accepts positive argument", + "=MINUTE(\"\")": "#VALUE!", + "=MINUTE(\"13:60:55\")": "#VALUE!", // MONTH "=MONTH()": "MONTH requires exactly 1 argument", "=MONTH(0,0)": "MONTH requires exactly 1 argument", |