When I use the MINUTE() Function in excel, instead of the minutes being returned it always returns 0:00:00, any idea why this occurs?

CodePudding user response：

Change your formatting to be a number.

=MINUTE(10/60/24) returns 10.

Any whole number is equivalent to midnight on some date.

Converted to a time format, every whole number appears as ”0:00:00”