How to convert time to minutes in an Excel 2013 cell

ideas for solving problems

First, the hour function extracts the number of hours of C2 cells by 8, multiplies 60 by 480 minutes, and, second, extracts 480 minutes of C2 cells with the minute function, 15, and the result is 495. The last 495 plus the second function extracts the number of seconds of the C2 cell 0, the second 0 divided by 60 (the result is 0) into minutes, and the final result is 495 minutes.

　　Case Teaching

① We start Excel2013, the data I am ready, to change the minutes to minute format, the people who have learned mathematics know that 1 hours equals 60 minutes, 1 minutes equals 60 seconds, so here our formula can write: =hour (C2) *60+minute (C2) + SECOND (C2)/60

② carriage return Get the result, show is 0:00:00, how wrong? We'll change the format of the cell to normal.

③ Double-click the fill handle to complete the calculation of the remaining data.

Formula meaning

Hour (time): Returns the number of hours for a time value.

Minute (time): Returns the number of minutes for a time value.

Second (time): Returns the number of seconds for a time value.

Classification:

• Excel Tutorials