假设2012/01/02/2:00等内容写在A列,A1单元格开始的数据
则B1单元格写入公式
=TEXT(TRUNC((HOUR(SUBSTITUTE(A3,"/"," ",3))+MINUTE(SUBSTITUTE(A3,"/"," ",3))/60)/10,2),"0.00")
或
=TRUNC((HOUR(SUBSTITUTE(A3,"/"," ",3))+MINUTE(SUBSTITUTE(A3,"/"," ",3))/60)/10,2)
下拉复制公式
你这根本就不是日期时间的格式呀
就算是时间格式，5：00也不是0.5呀
a1=2012/01/02 2:00
b1=TEXT(TEXT(A1,"h")/10,"0.0") 即0.2
不经常用
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024