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
Format>Cell>Number>Custom> 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.
