how do I convert a value into timevalue on excel?
 

For example 1=20 mins, 2=40 mins so 5=1.4

how do I convert a value into timevalue on excel?
 

Hi blondie

It depends upon how your original 20 mins are held
If cell A1 is 0:20 then =5*A1 will give 1:40
if cell A1 is 20 then you need = 5*A1/1440 and format the cell with the
formula
FormatCellNumberCustom hh:mm

Excel stores times as fractions of a day.
Therefore, dividing your result of 100 minutes by (60*24 = 1440 minutes)
gives the correct result.

--
Regards

Roger Govier


"blondie" wrote in message
...
For example 1=20 mins, 2=40 mins so 5=1.4