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

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 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