Date and time calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi Tony

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

Cheers
JulieD
 
or even

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

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pls help for Simple Calculation 1
Subtraction formula 7
Average Time for Specific Item 9
Determine if night shift by start & end time 2
Formatting time 2
Formatting Date Field 5
LOOKUP function between two dates in Excel 2007 6
Calculate time worked based on start / end times & working hours 3

Back
Top