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

  • Thread starter Thread starter Tbone
  • Start date Start date
T

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
 
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.
 
Back
Top