From 5de671f8bb8a4d8951d5511c3bd1745fc46ce842 Mon Sep 17 00:00:00 2001 From: xuri Date: Fri, 12 Nov 2021 01:01:50 +0800 Subject: ref #65: new formula function MINUTE --- calc_test.go | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'calc_test.go') 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", -- cgit v1.2.1