Excel MINUTE function returns 0:00

Atheek Nazeer 0
Viewed 32

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?

enter image description here

enter image description here

minute xls excel
1 Answers

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”

JSmart5230
Related