View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default I want to add and less the time in excel

Good question. Try:

=A1-9.3/24 whcih will display 10:12:00 AM

the /24 converts to fraction of a day.
--
Gary''s Student - gsnu200802


"I want to add and less the time in excel" wrote:

Hi,

I want to (-) the time in existing for Exg. 7:30 PM if i will -9.30hrs i
will get the time 10.15 AM. Please can any one send me the formula how to
add and less the time in existing time