I am trying to multiply an elapsed time (hh:mm:ss) with a multiplier (0.000) to get an adjusted time with the result in hh:mm:ss format. I am using the stripduration formula but it returns a number, not a time format. Example row:
any help is appreciated as I am not a programmer.
MacBook Air, macOS 13.5
I'm not sure what I'm missing here.
What's wrong with cell J2 just being set to:
=I2 * F2
On my system that returns:
39m 24s 695ms
which can be easily formatted as HH:MM:SS using the Cell -> Format -> Duration options:
I'm not sure what I'm missing here.
What's wrong with cell J2 just being set to:
=I2 * F2
On my system that returns:
39m 24s 695ms
which can be easily formatted as HH:MM:SS using the Cell -> Format -> Duration options:
Numbers- calculating sailboat racing adjusted times
