View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
egun egun is offline
external usenet poster
 
Posts: 88
Default Time is driving me crazy

Excel should be treating the time you past in as a date. If you add one to a
date, you are adding a day:

Jan-01-2009 + 1 = Jan-02-2009

There are 24*60*60 seconds in a day. So, to add just one second, you need
to add a much smaller amount:

TimeNow = StartTime + 1# / 24# / 60# / 60#

Of course, you need to format that column as a time (something like HH:MN:SS)

HTH,

Eric