Excel Guides

Working with Minutes in Excel

Working with minutes in Excel can be a bit tricky, but with a few simple tips you can easily become a pro! Here are some things to keep in mind:

  • To enter minutes into a cell, you must use the colon (:) as the separator between hours and minutes. For example, to enter 1 hour and 15 minutes, you would type "1:15" into the cell.
  • You can also enter hours and minutes using the "h" and "m" format. For example, to enter 1 hour and 15 minutes, you would type "1h15m" into the cell.
  • If you want to add or subtract minutes from a time value, you need to use a formula. For example, to add 15 minutes to a time value in cell A1, you would use the formula =A1+TIME(0,15,0).
  • To format cells that contain time values, you can use the "hh:mm" format. This will display hours and minutes with leading zeros (00:15), which can be helpful when working with times that include seconds or milliseconds.

With these tips in mind, you should be able to work with minutes in Excel like a pro!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.