|
||
|
Senior Member
 
加入日期: Jan 2002
文章: 1,299
|
[求救] 請教execl達人 ^^"
請問execl 要怎樣將時間做運算?? 謝謝~~
2007/11/24 01:13:00 PM =A1 2007/11/24 01:13:00 PM =B1 501 =A2 540 =B2 (B1-A1)/(B2-A2) <---這用exexl要樣寫!! |
|||||||
2007-11-24, 01:29 PM
#1
|
|
|
Regular Member
 加入日期: Aug 2006
文章: 88
|
我所想到的是轉成分或秒去做計算......
|
||
|
2007-11-24, 11:26 PM
#2
|
|
|
Major Member
加入日期: Apr 2004
文章: 127
|
利用DATEVALUE()或TIMEVALUE()
|
|
2007-11-25, 01:49 AM
#3
|
|
