I want to add and less the time in excel

[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

 

[Gary''s Student]

Good question. Try:

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

the /24 converts to fraction of a day.

 

[Sandy Mann]

"I want to add and less the time in excel" <I want to add and less the time
in (e-mail address removed)> 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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk