i NEED THE DIFFERENCE OF DATES DOWN TO YEARS...IE 11/1/02-4/16/85.

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

Guest

I need to know how to create a formula that will determine the difference of
dates down to the exact number ie 17.6
 
To get that you need times as well as dates since dates entered as dates
will always be integers
(from midnight to midnight)

with start date time in A1 and end in B1

=INT(B1-A1)+MOD(B1-A1,1)

format as General

--


Regards,

Peo Sjoblom
 
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

Year Totals 1
Date Formula 85 factor 7
Modifying a complex date formual to count months 4
difference between the dates ex: 4/11/2008- 7/11/2008= 3 days 3
Look up a text value then count records < a date 3
Time and the Max Function 15
Count entries in the column translating to minutes. 5
change a list of 2 digit years to 4 digit years? 5

Back
Top