Thread: How do I summarize unusual column data?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kila Kila is offline
external usenet poster
  
Posts: 4
Default How do I summarize unusual column data?
I have a column of data that is in the following format:

2:37:56 (2 hours:37 minutes:56 seconds)

How can I have the summary cell display an average days/hours/minutes for
the entire column? Thanks.
Reply With QuoteReply With Quote