Date and time calculations

Tony · Jan 8, 2005

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

JulieD · Jan 8, 2005

Hi Tony

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

Cheers
JulieD

Bob Phillips · Jan 8, 2005

or even

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

--

HTH

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