How to Use the ROUND function to round time values to whole minutes
A worksheet contains time values including hours, minutes, and seconds as shown in the picture below. The task is to round the minutes to whole minutes by using the standard ROUND function. Note that a day has 24 hours, which is 1440 minutes.
To round different time values to whole minutes:
- In cells A2:A10 list some time values in this format: 12:02:59 AM.
- Select cells B2:B10 and type the following formula: =ROUND(A2*1440,0)/1440.
- Press Ctrl+Enter.
This tip is compatible with Excel 97, 2000, 2003 and 2007.
- How to Convert from hours to minutes in Excel
- Use the FLOOR function to round down values to the nearest 100
- Use the MROUND function to round values to the nearest multiple of 10 or 50
- How to Use the CEILING function to round up values to the nearest 100
- How to Use the ROUND function to round numbers in Excel
