View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default EXCEL time match

Hi,

Am Fri, 6 May 2011 08:08:08 -0700 (PDT) schrieb Bantham:

I know ther is a difference in the time because the seconds keep
changing and the floating point issue, is there a way that I can
achieve this ?


in D5 try:
=D4+TIME(,45,)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2