MS Excel: How to format cells to show time with minutes and seconds but the hours only when needed?
with hours, minutes and seconds but if the time is less that one hour, then this way:
without preceding zero or colon.
Not this: 0:23.45
These formats didn't give results I wanted:
The cells contain formulas and are read by other cells as time, so they must stay as times.
I suppose I'll just live with the preceding zero and colon. Because of your labor, at least I won't have to continue searching for a format. Thanks again.