Multiplying times
unfortunately no
"Tyro" wrote:
Does the "other" program provide Excel times??? Formatting is for human
consumption. You have to provide numbers to Excel that represent Excel's
times - ie. fractions of 24 hours.
Tyro
"dpwicz" wrote in message
...
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
|