"Evan" wrote:
Just corrected a mistake, function is now =TIMEVALUE(TEXT(I3, "mm:ss"))

Yes, I noted a number of iniconsistencies in your original posting. But....


such that 3:00 = .125, 02:04 = .166666667 the difference = -0.41666667.

0.125 is 3h 0m -- 03:00 in "hh:mm" format -- and 0.166... is 4h 0m, nothing
like 2:04 in any format.

Moreover, 0.125 - 0.166... is -0.04166..., not -0.4166... .


So I have a new problem a negative number.

You have a problem with presenting your problem reliably.

If you have a question about a formula you are using, it would be prudent to
show the formula and all relevant values, using copy-and-paste, as well as
the result you want to see. In your case, it might be important to present
time values both as they appear and in Number format with at least 6 decimal
places.


Is this more easily solved by converting all time into seconds using
86400?

Without knowing what you are trying to do, it is hard to say. For the most
part, that is not likely to solve your problem. However, it might improve
the accuracy of your result.


----- original message -----

"Evan" wrote in message
...
Just corrected a mistake, function is now =TIMEVALUE(TEXT(I3, "mm:ss"))
such
that 3:00 = .125, 02:04 = .166666667 the difference = -0.41666667. So I
have
a new problem a negative number. Is this more easily solved by converting
all time into seconds using 86400? Then my problem is how to convert the
seconds back to a mm:ss format. Already trid to format the column using
Format Custom mm:ss but it doesn't work.

"Evan" wrote: