excel 每兩分鐘sort 數

fung

2014-12-22 6:43 pm

我有的資料/數值如下, 想由show每秒鐘的數變成show每兩分鐘的數, 應該怎樣set?? Thanks!
A B
１　 4/11/201410:38:01
２　 4/11/201410:38:02
３　 4/11/201410:38:03
４　 4/11/201410:38:04
５　 4/11/201410:38:05
６　 4/11/201410:38:06
７　 4/11/201410:38:07
８　 4/11/201410:38:08
９　 4/11/201410:38:09
X　Ｘ　　　　　Ｘ
X 　Ｘ　　　　　Ｘ
X　Ｘ　　　　　Ｘ
X　Ｘ　　　　　Ｘ
43191 4/11/201422:37:55
43192 4/11/201422:37:56
43193 4/11/201422:37:57
43194 4/11/201422:37:58
43195 4/11/201422:37:59
43196 4/11/201422:38:00

回答 (1)

Eddie

2014-12-23 12:19 am

✔ 最佳答案

1 minute=1/(60*24) of a day, 2 minutes=2/(60*24) of a day.
Suppose B1 is the starting time and need not be added 2 minutes, B2 is the first cell to start adding 2 minutes.
B1:=NOW()
B2:=B1+(ROWS(B$1:B2)-1)*2/(60*24)
Copy cell formula in B2 to B3:B43196.
The ROWS() function counts the number of rows between current row and the first row, this can be used to determine how many '2-minute' intervals to be added.

👍 0 👎 0