Re: $$Excel-Macros$$ Format Conversation Question

2012-04-02 Thread Maries
Hi, Try below formula for TOI values. =TEXT(A1,"h:mm AM/PM") Regards, MARIES. On Mon, Apr 2, 2012 at 1:40 AM, qcan wrote: > > > Hi, > > There is probably a very simple solution here, but I am stumped. > > In this link below, you will see a table that has a field called "TOI" > (abbreviation

$$Excel-Macros$$ Format Conversation Question

2012-04-01 Thread qcan
Hi, There is probably a very simple solution here, but I am stumped. In this link below, you will see a table that has a field called "TOI" (abbreviation for time on ice). The number is visually set up as minutes and seconds. When I bring this into excel, I am unable to convert this into