How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell.
For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and
number of hours in this length of time? What is the total hours in this
length of time? I did look for the DateIf funtion in my Excel 2003 version, I
did not locate it.

You can use regular arithmetic on date/time cells in Excel. So the formula is:

=a2-a1

Custom format as dd hh:mm

If you want the number of hours, format as [hh]:mm

Also there's no DateIf function. There is a Datedif function in the Analysis
Toolpak addin, which may be what you are looking for.

--
Regards,
Fred


"Debby_Jo" wrote in message
...
How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell.
For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and
number of hours in this length of time? What is the total hours in this
length of time? I did look for the DateIf funtion in my Excel 2003 version, I
did not locate it.

Are you sure that DateDif needs Analysis ToolPak, Fred? I didn't think it
did.

It isn't explained in Excel help, but there is information at
http://www.cpearson.com/excel/datedif.htm
--
David Biddulph

"Fred Smith" wrote in message
...
You can use regular arithmetic on date/time cells in Excel. So the formula
is:

=a2-a1

Custom format as dd hh:mm

If you want the number of hours, format as [hh]:mm

Also there's no DateIf function. There is a Datedif function in the
Analysis Toolpak addin, which may be what you are looking for.

"Debby_Jo" wrote in message
...
How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell.
For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and
number of hours in this length of time? What is the total hours in this
length of time? I did look for the DateIf funtion in my Excel 2003
version, I
did not locate it.

Thank you very much, I believe this will do the trick.

"Fred Smith" wrote:

You can use regular arithmetic on date/time cells in Excel. So the formula is:

=a2-a1

Custom format as dd hh:mm

If you want the number of hours, format as [hh]:mm

Also there's no DateIf function. There is a Datedif function in the Analysis
Toolpak addin, which may be what you are looking for.

--
Regards,
Fred


"Debby_Jo" wrote in message
...
How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell.
For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and
number of hours in this length of time? What is the total hours in this
length of time? I did look for the DateIf funtion in my Excel 2003 version, I
did not locate it.

Good point. I thought it was part of ATP, but Chip's site doesn't mention
anything about it, so I'd have to assume it comes with regular Excel. I have ATP
installed on my system, so can't test it, and as you say, it isn't in Help.

--
Regards,
Fred


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
Are you sure that DateDif needs Analysis ToolPak, Fred? I didn't think it
did.

It isn't explained in Excel help, but there is information at
http://www.cpearson.com/excel/datedif.htm
--
David Biddulph

"Fred Smith" wrote in message
...
You can use regular arithmetic on date/time cells in Excel. So the formula
is:

=a2-a1

Custom format as dd hh:mm

If you want the number of hours, format as [hh]:mm

Also there's no DateIf function. There is a Datedif function in the Analysis
Toolpak addin, which may be what you are looking for.

"Debby_Jo" wrote in message
...
How do I calculate dates and times, with answer of days & hours and then
answer of total hours in another cell.
For example 4-1-07 15:00 to 4-10-07 14:00. What is the number of days and
number of hours in this length of time? What is the total hours in this
length of time? I did look for the DateIf funtion in my Excel 2003 version,
I
did not locate it.