The contents of that cell is gonna be 12:05:29 AM no matter what (unless you
change the format to text and type what you want). That's just the way excel
treats times.

You can display it in the cell anyway you want using the format you like.

If you want to use a helper cell that converts that time to a string, you could
use a formula like:

=TEXT(A1,"[=0.0416666666666666][h]:mm:ss;[m]:ss")



Pam wrote:

We have been getting an Excel file from a vendor that had numbers in a
General format. This worked great for our purposes (exporting to Access).

Example:
Actual contents of A1: 58.36
Display of A1: 58.36
This is what we want....

This time around the file has been sent to us and the numbers are not in
General format, but a Custom format that looks like this:

[=0.0416666666666666][h]:mm:ss;[m]:ss

Actual contents of A1: 12:05:29 AM
Display of A1: 5:29
We want the display of 5:29 to be the real contents of the cell. Not the
time format that is currently there.

When we change the format to General, we get:

Contents of A1: 12:05:29 AM
Display of A1: 0.00380787
So, just changing it to General isn't the 'magic' that we need.

Any ideas?

BTW: The vendor is disavowing any knowledge of their actions! We are still
trying to work with them.

TIA!

--

Dave Peterson