Ok so Excel will interpret them as 4 hours and 2 minutes.
If you format B1 as [hh]:mm it will show what appears
to be the correct answer i.e. 80:40 which hopefully shouldn't
bother you, so long as you remember that what you are viewing
as minutes and seconds is in reality hours and minutes. With
everything based on 60 it should all work the same.

Or is there some other reason that you can't work with this little deception.

HTH
Martin

"dpwicz" wrote:

The times are being taken from anothere program and are already entered in
the 4:02 format, so I really don't want to reenter them.

"MartinW" wrote:

Hi,

With your time in A1, put =A1*20 in B1
Couple of things to watch.
Format both cells to [mm]:ss (not mm:ss)
Input your time as 00:04:02
If you input it as 4:02 it will be 4 hours and 2 minutes

HTH
Martin


"dpwicz" wrote in message
...
Hello,

I need to multiply a time written in the format (m:ss) times a number for
instance 4:02 by 20. What would be the best way of doing this?

Thank You,
David