Converting a custom format number into a plain number

[hsshah]

Hi,

I am working on a report and I have a column which calculates the outage details of different sites in the [m] or minute format (I hope I am right?).

Now whenever I do operations on any entry of this column I see values in points.

e.g if the number in [m] format was 50 and I multiply it with 2 I get the value of 0.06944444. Now I have to use this 50 at multiple occasions and apply different calculations on it. So I want to format this number in such a way that it displays 50(mins) and acts as a plain number 50

Is it possible?

Thanks in advance

 

[JB_Scotland]

Your [m] 50 x 2 is represented by the value .06944444 because the 50 is in a date / time format where 1 = a whole day. 1 minute = 1/(24*60) and 50 minutes = 50/(24*60) or 0.034722222 of a day.

You can either format your calculations columns as [m] also to display the results in minutes or you can multiply your 50 by (24*60) or 1440 and format the cell as an integer or decimal number.