Add Seconds to Date - Time Field

T

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
 
R

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
 
T

terminal euphoria

Thanks a-lot - that did it!

Roger Govier said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top