excel批量增加10分钟

Question

如A1是“2015-4-8 AM 7:03”，希望B1是“2015-4-8 AM 7:13”，请问怎样利用公式批量实现啊？

Answer 1

B1
=LEFT(A1,FIND("@",SUBSTITUTE(A1," ","@",2))-1)&" "&TEXT(RIGHT(A1,LEN(A1)-FIND("@",SUBSTITUTE(A1," ","@",2)))+10/(24*60),"hh:mm")
下拉追问

你好，问什么
”2015-4-8 PM 16:42“
用了这个公式后变成“1900-1-0 AM 12:00“了啊 ，我是想要”2015-4-8 PM 16:52“，麻烦高人再指点一下啊

Answer 2

=A1+1/144

Answer 3

=A1+"0：10"

Answer 4

B1=A1+(10/60)/24