I have formulas to help me calculate totals from times, but they won't work if there is no hour. Some of my figures include an hour, minute, and second (1:01:40). Others include only the minute and second (:08:52). I need a way to easily get a zero in front of the first colon otherwize my formula won't handle those values.
Any ideas?
Thank you,
Kevin
Bookmarks