Peter,

Format your cells as custom - h:mm:ss under the Number tab in Format Cells.
Enter the data as 0:min:sec
You should be able to add up the lengths in this way.

Is that what you are looking for?



"TPS_Reports" wrote:

I am trying to put together a sheet for my small company for cell phone cost
analysis. My phone bill displays time used in this format Min:Sec
I would like to know how I can format a cell to understand this. Also,
maybe someone might be doing something similiar to this and could suggest
some useful formulas.