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
|