Hi
I want to add 17.22 seconds to the current time in custom format ie hh:mm:ss.00
eg lets say the current time is : 15:59:30.17, I would like a formula to add 17.22 seconds to it in this case the result would be
15:59:47.39 What's the formula to do this?
Also
I then have a column full of times base on the calculation and would need to find the earliest time of this range.
What would be the best approach, I've been trying the SMALL() or MIN() function. Will this work or is there a beater way.
Cheers
Chris
Bookmarks