Excel中最近15分钟的周期 [英] Round time to nearest 15min interval in Excel

问题描述

我有一个excel电子表格，其中列有特定事件的日期和时间。我想将其舍入到最近的15分钟间隔，以便我可以计算这个时期的事件总数。

解决方案

既然你说你也想要这个日期，那怎么样呢？ / p>

=（ROUND（（A1 * 1440）/ 15，0）* 15）/ 1440

假设A1有你想要的日期/时间值。这充分利用Excel中的日期/时间列只是数字（整数部分是日期，小数部分是时间）的事实

I've an excel spreadsheet with a column which has the date and time of a particular event. I would like to round this to the nearest 15 minute interval so that I can count the total number of events in this period. What is the best way to do do the rounding?

解决方案

Since you said you also want the date, how about this:

= (ROUND((A1 * 1440) / 15, 0) * 15) / 1440

Assuming that A1 has the date/time value you want. This takes advantage of the fact that date/time columns in Excel are just numbers (integer portion is the date, fractional portion is the time)

这篇关于Excel中最近15分钟的周期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！