excel

[tgjla]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel am running an experiment needing to set the time to every 5 seconds/ how do i set up the time column eg 12:23:34 is C 1 cell. what formula do i do for the next instead of typing it ?
=C1 + (0,0,5) when i do this it tells me error or invalid

 

[CyberTaz]

Unless you have a need for the times to update based in changes to what's in
C1 I wouldn't worry with a formula at all. Just enter the next increment in
C2 as 12:23:39 then select the 2 cells & use the Fill Handle to extend the
series as far down the column as necessary.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

BTW, your question has absolutely nothing to do with the topic of this
thread, so it's improper to post a REPLY. For future queries, please post as
a NEW MESSAGE separate from other existing messages.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[CyberTaz]

PS: If the time in C1 will need to be changed periodically your formula in
C2 would have to be: =TIME(HOUR(C1),MINUTE(C1),SECOND(C1))+TIME(0,0,5)
although there may be more elegant ways to express it.

Keep in mind that TIME in Excel is stored as a serial value but displays as
the time of day. It isn't a 'quantity' of hours, minutes & seconds. IOW,
your example in C1 is "23 minutes & 39 seconds after 12 o'clock Noon", not
"12 hours, 23 minutes, & 34 seconds". In order to involve it in calculations
it's necessary to extract the serial value, then add to or subtract from it.

Regards |:>)
Bob Jones
[MVP] Office:Mac