Multiplying times
Excel maintains times as fractions of 24 hours. 1 hour is 1/24, 1 minute is
1/(24*60) and 1 second is 1/(24*60*60). So if you enter 00:00:10 which is 10
seconds, Excel will store that as 1/(24*60*60) * 10 - i.e.
0.000115740740740741. If you display that with a format of hh:mm:ss you will
see 0:00:10 in the cell and 12:00:10 AM in the formula bar. 12 midnight is
0.0 Time is just a number so, simply multiply and display the time as
hh:mm:ss or [h]:mm:ss if the time is greater than 24 hours.
Formatting is for human consumption. So, to multiply 10 seconds by 20,
simply enter the time 0:00:10 and multiply by 20 to get 200 seconds which is
0.00231481481481482 and format that as hh:mm:ss to see 0:03:20 - 3 minutes
and 20 seconds.
Tyro
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
|