how are you all, i need to know if there is a function or a direct method to find the sum cells that contain time in it in this format hh:mm:ss, and the sum of hh may be more than 24.
Under Format, go to "cells", click on time and choose the desired format. Then all you need to do is apply your formula to the cells you wish to include.
__________________
The last fight was my fault. My wife asked "What's on the TV?" I said "Dust!"
how to calculate sum 'time' in Excel 
Re: how to calculate sum 'time' in Excel
