I have a time field that displays data such as 0:35, 25:42:00, 16:00, etc.
which is the total hours for a category. My goal is to add all these up to
get a total of these hours by category. When you click on a cell, the
formula bar shows things like 1/1/1900 1:42:00 AM instead of 25:42:00. Can
you tell me how to convert the data to actual hh:mm:ss so I can add them up?

Many thanks!