Need formula to add increments of 0.16 seconds to time
 

Need assistance in development of a formula to add increments of 0.16 seconds
to time formated as 00:00:00.00 (hh:mm:ss.00).

Tim,

=A2 + TIMEVALUE("0:0:0.16")

--
Earl Kiosterud
www.smokeylake.com

"Tim Ashcom" <Tim wrote in message
...
Need assistance in development of a formula to add increments of 0.16
seconds
to time formated as 00:00:00.00 (hh:mm:ss.00).

Hi,
Say the date/time is in A1, use:
= A1 + 16 * (1/24/60/60/100)
ie:
one day is 1 for excel therefore
- 1/24 is 1 hour
- 1/24/60 is 1 minute
- 1/24/60/60 is 1 second
- 1/24/60/60/100 is 1/100 of a second
--
Regards,
Sébastien


"Tim Ashcom" wrote:

Need assistance in development of a formula to add increments of 0.16 seconds
to time formated as 00:00:00.00 (hh:mm:ss.00).