Hi all,

In one cell I have the decimal time: 04:95, which is the result of a formula.
When I try to convert it in another cell to a value or text the result is: 5:53

The problem is that I got a macro that copies the cells from 1 sheet as values into another. As I don't want the code to be changed what are the options?