| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formating dates
I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
=B1-A1 format as general (end date - start date)
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
Oops! didn't read far enough, see Biff's answer
Peo "Peo Sjoblom" wrote in message ... =B1-A1 format as general (end date - start date) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
Hi!
A1 = start date/time B1 = end date/time =INT(B1)-INT(A1) Biff "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
I guess I did not explain well enough
In A1 I have Wed 12 Apr 2006 01:46:PM In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4 min and a few seconds. What I really wnat is the number of days(in this case it wouod ab e about ..8(point 8) How can I do that Thanks "Biff" wrote: Hi! A1 = start date/time B1 = end date/time =INT(B1)-INT(A1) Biff "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
As long as these dates are true Excel dates then just subtract:
=A1-B1 Format the cell as GENERAL Result = 0.878472222218988 Biff "pcor" wrote in message ... I guess I did not explain well enough In A1 I have Wed 12 Apr 2006 01:46:PM In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4 min and a few seconds. What I really wnat is the number of days(in this case it wouod ab e about .8(point 8) How can I do that Thanks "Biff" wrote: Hi! A1 = start date/time B1 = end date/time =INT(B1)-INT(A1) Biff "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Formating dates
Worked Great Thanks
"Biff" wrote: As long as these dates are true Excel dates then just subtract: =A1-B1 Format the cell as GENERAL Result = 0.878472222218988 Biff "pcor" wrote in message ... I guess I did not explain well enough In A1 I have Wed 12 Apr 2006 01:46:PM In B1 I have Tue 11 Apr 2006 04:41:PMTThat give me an answer of 21 hrs 4 min and a few seconds. What I really wnat is the number of days(in this case it wouod ab e about .8(point 8) How can I do that Thanks "Biff" wrote: Hi! A1 = start date/time B1 = end date/time =INT(B1)-INT(A1) Biff "pcor" wrote in message ... I have dates and times in 2 cells(a1 and b1). How do I format an other cell(c1) to tell me hiow many days there is between cells (a1 and B1). Thanks Ian |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating dates | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| conditional formating: dates | Excel Worksheet Functions | |||
| conditional formating using cells containg dates | Excel Discussion (Misc queries) | |||
| Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Hybrid Mode
