Add Seconds to Date - Time Field
Thanks a-lot - that did it!
"Roger Govier" wrote:
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 FormatCellsNumberCustom m/dd/yyyy hh:mm:ss
--
Regards
Roger Govier
"terminal euphoria" wrote in
message ...
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
|