# How to convert time to minutes in Excel

Multiply by 1,440, the minutes in a day: `=B2*1440` turns 1:15 into 75.

**Excel:** `=B2*1440` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C |
| --- | --- | --- |
| Meeting | Length (h:mm) | Minutes |
| Kickoff | 0.052083333333333336 |  |
| Design review | 0.03125 |  |
| Workshop | 0.10416666666666667 |  |
| Check-in | 0.005555555555555556 |  |
| Planning | 0.1284722222222222 |  |

Formula in C2, filled to C6: `=B2*1440`

Result: 75; 45; 150; 8; 185

## How it works

Times are fractions of a day and a day has 1,440 minutes, so multiplying by 1440 gives minutes: 1:15 is 75 minutes and 3:05 is 185.

## Other ways

- `=ROUND(B2*1440,0)`: Whole minutes, which avoids results like 74.9999999. (Rounds to whole minutes when the time includes seconds.)
- `=B2*24*60`: Hours times 60; the same result.

## Common mistakes

- The result can show as a time like 0:00 because it inherits the time format. Format the cell as a number.
- If B2 includes a date, take the time part first: `=MOD(B2,1)*1440`.

## Questions

**How do I convert time to seconds?**

`=B2*86400`.

**How do I convert minutes back to a time?**

`=C2/1440`, formatted as h:mm.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/convert-time-to-minutes