| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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). |
|
#2
|
|||
|
|||
|
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). |
|
#3
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
| revert formula insertion to old method | Setting up and Configuration of Excel | |||
Linear Mode
