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
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