When I format cells to number>time>and choose 13:01 the cell defaults to clock time rather than Min:Sec. For instance, typing in 6:47 displays 6:47:00 AM. What format can I be in so I can a column of min:sec and get a sum of hr:min:sec. I must be missing something.
Bookmarks