2008年4月4日 - Assume in Cell A1 you have [23:00] and cell B1 you have [17:00], in cell C1,you can just simply put =A1-B1 you will see 6:00, which means 6 hours ...
hk.knowledge.yahoo.com