Did you enter your time as 0:04:02? That is 0 hours, 4 minutes and 2
seconds. That time when multiplied by 20 returns 1:26:40 - ie. 4 minutes and
2 seconds multiplied by 20 is 1 hour, 26 minutes and 40 seconds. If you
enter 4:02 that is 4 hours and 2 minutes and if you multiply that by 2, you
get 8:04 - ie 8 hours and 4 minutes. If you multiply by 20 you get 80:40:00
when formatted as [h]:mm:ss - that is 80 hours and 40 minutes.

Tyro

"dpwicz" wrote in message
...
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