作者在 2008-10-23 11:06:34 发布以下内容
| 时间求差 | TEXT(E109-E110,"hh:mm:ss") |
| 时间求和 | TEXT(E109+E110,"hh:mm:ss") |
例
|
E |
F |
G |
||||||
| 23 | 2008-10-20 17:54:43 | 00:01:33 | = | TEXT(F23-F24,"hh:mm:ss") | ||||
| 24 | 2008-10-20 17:53:10 | |||||||
| 25 | 2008-10-22 13:12:53 | 00:01:53 | = | TEXT(F25-F26,"hh:mm:ss") | ||||
| 26 | 2008-10-22 13:11:00 | |||||||
| 27 | ||||||||
| 28 | 00:03:26 | = | TEXT(G23+G25,"hh:mm:ss") | |||||
多个Excel表格相加 =TEXT(G23+G25+G27+G29+G31....,"hh:mm:ss")
