I want to add and less the time in excel
 

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

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

I want to add and less the time in excel
 

"I want to add and less the time in excel" <I want to add and less the time
in wrote in message
...
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


No but I can get it to 10:00 AM. With 9:30 AM in an unused cell, copy it
and then Paste Special Subtract over the 7:30 PM cell to get 10:00 AM
--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk