I want to add and less the time in excel

  • Thread starter I want to add and less the time in excel
  • Start date
I

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
 
G

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

Sandy Mann

"I want to add and less the time in excel" <I want to add and less the time
in [email protected]> 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
Click to expand...

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top