Add Seconds to Date - Time Field

[terminal euphoria]

I have an Excel spreadsheet that provides a date/time field in one column and
a seconds field in another column. How can I combine the seconds to this
Date/time field?
Example:
Column A Column B
Date/Time Seconds
8/30/2008 9:22:00 AM 44
8/30/2008 9:18:00 AM 27
8/30/2008 7:03:00 AM 23

 

[Roger Govier]

Hi

Excel stores times as fractions of a day.
there are 86400 seconds in a day, so to add your time you would need
=A2+B2/86400
Format the cell as Format>Cells>Number>Custom> m/dd/yyyy hh:mm:ss

 

[terminal euphoria]

Thanks a-lot - that did it!

Hi

Excel stores times as fractions of a day.
there are 86400 seconds in a day, so to add your time you would need
=A2+B2/86400
Format the cell as Format>Cells>Number>Custom> m/dd/yyyy hh:mm:ss