在ＶＦＰ中，两个时间值怎么才能相减得出它们之间相差的分钟数？要命令。。。谢谢。。 EXCEL高手，如何让两个时间相减，得出多少分钟？
vfp\u4e2d\u8981\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u95f4\u76f8\u5dee\u5929\u6570\u5982\u4f55\u7f16\u5199\u7a0b\u5e8f\uff1fLocal date2,date1
date2 = ctod('2014-12-19')
date1 = ctod('2014-10-20')
if (date2-date1)<30 then
messagebox('\u76f8\u5dee'+transform(date2-date1)+'\u5929')
else
if MOD(date2-date1,30) = 0 then
messagebox('\u76f8\u5dee'+transform(Floor((date2-date1)/30))+'\u4e2a\u6708')
else
messagebox('\u76f8\u5dee'+transform(Floor((date2-date1)/30))+'\u4e2a\u6708'+transform(MOD(date2-date1,30))+'\u5929')
endif
endif
绛旓細鍦级锛︼及涓紝涓や釜鏃堕棿鍊兼槸浠ョ涓哄崟浣嶇殑銆傛墍浠ヨ姹傚嚭涓や釜鏃堕棿涔嬮棿鐨勫垎閽熸暟灏卞簲璇ョ敤锛锛堜袱涓椂闂翠箣宸殑鍊/60锛+1=鍒嗛挓鏁銆
绛旓細tExpression 鎸囧畾鏃ユ湡鏃堕棿鍨嬭〃杈惧紡锛孲EC( ) 鍑芥暟杩斿洖璇ヨ〃杈惧紡鐨勭閮ㄥ垎銆傚鏋 tExpression 鍖呭惈鐨勫彧鏄棩鏈熻屾病鏈夋椂闂达紝Visual FoxPro 灏嗛粯璁ょ殑12: 00: 00 A.M. (濡傛灉 SET HOURS 鏄 12) 鎴 00:00:00 (濡傛灉 SET HOURS 鏄 24) 娣诲姞鍒 tExpression 涓骇鐢熶竴涓湁鏁堢殑鏃ユ湡鏃堕棿鍊銆
绛旓細琛ㄥ崟1.text2.value = date()琛ㄥ崟1.text3.value = date()+ ab 浠ｇ爜鎵ц缁撴灉鍦═extbox涓樉绀虹殑鏄123澶╁悗鐨勬棩鏈熴
绛旓細濡傛灉鍚湁 nExpression 鍙橀噺锛屽彲浠ヨ繑鍥炲寘鎷櫨鍒嗕箣涓绉鐨勬椂闂銆傛暟鍊艰〃杈惧紡 nExpression 鍙互鏄换浣曞硷紝鐒惰岋紝瀹為檯鐨勬渶澶х簿搴﹀兼槸 1/18 绉掋備娇鐢 SECONDS( ) 鍑芥暟鍙幏寰楁洿楂樼殑绮惧害銆傝繑鍥炲肩被鍨 瀛楃鍨
绛旓細鍊硷紝鍒欒繑鍥 Null 鍊笺俥LowValue 鎸囧畾 BETWEEN() 璁＄畻鑼冨洿鐨勪笅鐣屻俥HighValue 鎸囧畾 BETWEEN() 璁＄畻鑼冨洿鐨勪笂鐣屻傚娉 濡傛灉涓涓瓧绗﹀瀷銆佹棩鏈熷瀷銆佹棩鏈鏃堕棿鍨嬨佹暟鍊煎瀷銆佹诞鐐瑰瀷銆佹暣鍨嬨佸弻绮惧害鍨嬫垨璐у竵鍨嬭〃杈惧紡鐨勫鍦ㄥ彟澶涓や釜鐩稿悓鏁版嵁绫诲瀷琛ㄨ揪寮忕殑鍊间箣闂达紝BETWEEN()灏辫繑鍥炩滅湡鈥(.T.)锛屽惁鍒欒繑鍥炩滃亣鈥(.F....
绛旓細浣犲彲浠ヨ瘯璇昪tod()鍑芥暟锛屼緥濡俢tod("1998-09-01")
绛旓細浣犲彲浠ラ氳繃浠ヤ笅姝ラ鏉ヨ缃湁鏁堟ц鍒欙細鍦╒FP涓墦寮瑕佽缃湁鏁堟ц鍒欑殑琛ㄣ傚湪鈥滆〃璁捐鍣ㄢ濅腑閫夊畾瑕佸缓绔嬭鍒欑殑瀛楁鍚嶃傚湪鈥滆〃杈惧紡鐢熸垚鍣ㄢ濅腑璁剧疆鏈夋晥鎬ц〃杈惧紡銆傜‘璁や慨鏀广傝嚦浜庡鐞嗚缃"宸ヤ綔鏃堕棿"鍏跺间负90骞翠箣鍚庣殑鏈夋晥鎬ц鍒欙紝浣犲彲浠ラ噰鐢╠atetime()鍑芥暟浠ユ棩鏈鏃堕棿鍊锛屽叿浣撳涓 鍦╒FP涓紝浣犲彲浠ヤ娇鐢ㄥ绉嶅嚱鏁版潵...
绛旓細public time1 time1=time() &&淇濆瓨鏃堕棿鍒濆硷紝浠ュ悗娌￠殧涓绉掗挓閮藉拰杩欎釜鏃堕棿姣旇緝銆傚彟澶栧鍔犱竴涓枃鏈鎺т欢text1銆傝鏃跺櫒鏃堕棿闂撮殧(interval灞炴)璁句负1绉掞紙1000姣锛夊湪璁℃椂鍣╰imer1鐨則imer浜嬩欢涓啓涓:time2=time()hh1=val(subs(time2,1,2))-val(subs(time1,1,2))mm1=val(subs(time2,4,2))-...
绛旓細杈撳叆瀹屾瘯鎸夊洖杞﹂敭缁撴潫銆傚浜嶹AIT鏉ヨ锛孉CCEPT鍙兘鎺ュ彈瀛楃鍨嬫暟鎹紝涓嶉渶瀹氱晫绗︼紝杈撳叆瀹屾瘯鎸夊洖杞﹂敭缁撴潫銆傚浜嶪NPUT鏉ヨ锛孖NPUT鍛戒护鍙帴鍙楁暟鍊煎瀷銆佸瓧绗﹀瀷銆侀昏緫鍨嬨佹棩鏈熷瀷鍜屾棩鏈鏃堕棿鍨嬫暟鎹紝濡傛灉鏄瓧绗﹀瀷鏁版嵁锛岄渶鐢ㄥ畾鐣岀锛岃緭鍏ュ畬姣曡繎鍥炶溅閿粨鏉熴傚弬鑰冭祫锛VFP绋嬪簭涓彲浠ヤ娇鐢ㄥ摢涓夋潯杈撳叆鍛戒护,瀹冧滑鏈変粈涔堝紓鍚?
绛旓細CLEAR LOCAL nH, nM, nAVG && 8:50, 8.30, 8.45, 9.20 nAVG = (HM2M(8, 50) + HM2M(8, 30) + HM2M(8, 45) + HM2M(9, 20)) / 4 M2HM(nAVG, @nH, @nM)? "骞冲潎鏃堕棿:", STR(nH,2)+":"+ ALLTRIM(STR(nM))&& 鏃跺垎鏍煎紡杞垎閽熸牸寮 PROCEDURE HM2M(nH, nM)RETUR...
