Date and time calculations
 

Could any body advise the formula req to deduct 15Hrs from 10/12/2004 06:00
giving the result of 09/12/2004 15:00 many thanks
--
Tony

Hi Tony

in A1 10/12/04 06:00
in B1 15:00
in C1 =A1-B1

Cheers
JulieD

"Tony" wrote in message
...
Could any body advise the formula req to deduct 15Hrs from 10/12/2004
06:00
giving the result of 09/12/2004 15:00 many thanks
--
Tony

or even

="10/12/2004 06:00"-"15:00"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JulieD" wrote in message
...
Hi Tony

in A1 10/12/04 06:00
in B1 15:00
in C1 =A1-B1

Cheers
JulieD

"Tony" wrote in message
...
Could any body advise the formula req to deduct 15Hrs from 10/12/2004
06:00
giving the result of 09/12/2004 15:00 many thanks
--
Tony