Converting Time into Minutes using Excel
Feb 04, 2009 · The second column, B, is formatted as Numbers with 2 decimal places. The formula for the column B cells are =hour (A1)*60+Minute (A1) I enter 23:46 in the first column cell and get 1426.00 minutes in Column B1. This is correct. This formula work great, until I input anything greater then 24 hours in the first column.
DA: 84 PA: 25 MOZ Rank: 38