I tried that using my example of 4:02 by 20 it returns 8:20

"Fred Smith" wrote:

If your time is in a1, use:

=a1*20

Regards,
Fred.

"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