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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
