Time and date problem

T

Tom Weston

Hello
I have spreadsheet cell (B1) that contains a date and time:
05/11/2003 13:45:50
I have another series of cells (A1 to A100) that contain an increment of 30
seconds:
30.00
I would like to add the seconds to the date and time putting the result in
column C, I have tried to do:
=B1+(A1/100000) but the answer is wrong by 4 seconds and then gets worse the
further down the column I go.

Can somebody show me how to add the seconds to the date please.

Thanks

Tom
 
N

Nikos Yannacopoulos

Tom,

Right method, wrong divider! 86,400 secs in a day.. change
your 100000 to 86400 and you're there.

Nikos Y. (nyannaco at in dot gr)
 
H

Harald Staff

Hi

There are 24*60*60 seconds in 24 hours, so divide by 86400, not by 100000.
 
Top