Date and time plus xxx seconds

[West Man]

In A1 I have a start date mm/dd/yy, A2 has a start time hh:mm:ss (24 hr format). In A3 I have a field of seconds formatted as number. I wish to add these seconds to the starting date and time to get a 2 cell ending date/time, 1 with the ending date and 1 with the ending time. Suggestions?

 

[Scott Huish]

Assuming your seconds is a whole number:

=A1+A2+(A3/86400)

Format cells in the time and date format you want.

Book4
	A	B	C	D
1	1/1/2006		1/1/2006	01:00:23
2	1:00:00
3	23
Sheet1

 

[pgc01]

Hi West Man

If you the 2 values separated

End Date:
=INT(A1+A2+A3/86400)

End Time:
=MOD(A1+A2+A3/86400,1)

HTH
PGC

 

[West Man]

Thank you. I knew it must be easier than I thought.