The function rounds time to about half an hour or 15 minutes in Excel - Blog for knowledge sharing

Note: Please read the article carefully before proceeding! If in the process of using you encounter any errors, such as broken download links, slow loading blog, or unable to access a certain page on the blog ... then please inform me. here. Thanks!

In accounting, Excel statistics, etc., the time sheet is one of the most basic and essential parts in setting up a spreadsheet.

And in the previous articles, I also introduced to you a lot of ways to calculate time in Excel to serve different business needs. If you have not read it, you can refer to the section for self-study Excel on Blog.

To continue with the tips related to the time array in Excel, today, I will share with you How to use the MOD and FLOOR functions to round the minute value of the time about half an hour, or 15 minutes. Support for calculations, rounding time, employees' daily overtime is faster and more convenient.

Read more:

#first. How to use the MOD function to round time to about 30 minutes

+ Step 1: First you open the Excel file to be processed. Here you click on the cell to export the value.

Fifteen-minute-to-five-minute-hours-in-excel-minutes (1)

+ Step 2: Now enter the formula below => and press Enter to execute.

= MOD(INT (B2 / (1/48)) *(1/48);first)

In that box B2 is the time value reference cell to round.

FIGURE 15-minutes-in-Excel-15-minute-in-excel (2)

+ Step 3: Now we will get valuable results General of cell => next you choose the formula cell => and then click on the triangle icon in reverse Number Format in the tab HOME => and convert the format to Time as shown below.

FIGURE 15-minutes-in-Excel-15-minutes-in-excel (3)

Before filling the formula cell down the whole list => and we get the result of rounding the time 30 phút.

FIGURE 15-minutes-in-Excel-15-minute-in-excel (4)

#2. How to use the FLOOR function rounds time to about 15 minutes or set value

In addition to applying the MOD function to round the time value to 30 minutes. For spreadsheet requirements that require rounding to lower values, you can apply the function FLOOR in Excel.

Formula formula: = FLOOR(B2;TIME (0, 15, 0))

  • Reference value in cell B2, and the 15 minute time value in the range (1;15;1).
  • In case you need to round to a value less than 15 minutes, you can edit the value 15 It's about any value of yours. Before pressing Enter to execute.

FIGURE 15-minutes-in-Excel-15-minute-in-excel (5)

Then change the format General default to Time as shown below.

FIGURE 15-minutes-in-Excel-15-minutes-in-excel (6)

Finally, you fill the formula cell down the whole list to get the result of the time value rounded to about 15 minutes.

FIGURE 15-minutes-in-Excel-15-minute-in-excel (7)

# 3. Epilogue

Okay, that's it! I have just instructed you to add small tricks in using structure MOD and FLOOR functions to round the time value to half an hour, or 15 minutes ... in a very simple way.

Come here then post Instructions for rounding time in Excel I also would like to pause. Hope this tip will be helpful in your work.

Good luck !

CTV: Luong Trung -

Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!


seo marketing wordpress seo seo hosting seo and marketing word press seo wordpress and seo wordpress marketing hosting seo seo press pro market seo seo & marketing seo e marketing e marketing seo seo pro wordpress marketing & seo seo di wordpress wordpress seo host hosting and seo wordpress hosting seo wordpress seo wordpress wordpress for marketing seo press wordpress marketing for seo