Formats: Should be Duration MM:SS, but is really Time (12:30:00 AM)

[Tbone]

Thanks for the reply it does help some, but the issue is a littl
different.

It's not that I want to keep the data in a time format or do an
calculations based on the time, but rather I want to separate th
minutes and seconds on a per instance basis.

The export lists 00:30 as MM:SS, but when highlighted it reads 12:30:0
AM, and I know that the 00:30 is really only a 30 second entry, but
can't get that separated out of the cell without changing the data.

It is definitely an odd issues.

Thanks,
Tbon

 

[Fred Smith]

Let me see if I'm with you. You are importing 00:30, which in your data file
is mm:ss. However, Excel is interpreting the data as hh:mm. Is that the
problem?

There is no way Excel can tell the difference between an hh:mm format, and
an mm:ss format. Unfortunately for you, the developers of Excel picked hh:mm
as the default.

However, it's not all that hard to fix. Just divide the amount by 60. That
will change the time to 12:00:30 am, which is 00:30 in mm:ss format.