A couple of notes.

This only works for dates after 1/0/1900 ('0' is on purpose) and before
12/31/9999.

You only need [h]:mm as the custom format.

Dates are actually stored as the number of days from 1/0/1900. You can
verify this by entering a date and then formating the cell as a number. You
can't actually enter 1/0/1900, but you can enter 0 and format it as a date to
achieve a result of 1/0/1900 12:00AM.

Dates without times are entered as 12:00AM of that day.

You can do anything to dates that you can do to a number. Just realize that
the result is expressed in days, and must be formatted appropriately.

Example:
A1: 10/07/05 13:30
A2: 10/10/05 15:45
A3: =A2-A1 (results in 3.09375. Format as [h]:mm to appear as 74:15)
A4: =(A2-A1)*60 (results in 74.25 the decimal number of hours. Format as a
number or it might appear as something like 3/14/1900 6:00 AM)

"Dave Peterson" wrote:

> Just subtract the smaller from the larger and format the cell as: [hh]:mm
>
>
>
>
> DejaVu wrote:
> >
> > I need to figure out how to add dates and times in excel! I've been
> > playing around with it but can't seem to get it the way I need it.
> > Say, for example, I have two dates and times:
> > 1.) 10/07/05 13:30
> > 2.) 10/10/05 15:45
> > I want it to somehow return _74_hours_and_15_minutes_ in the form
> > *74:15*
> >
> > Is this possible!?
> >
> > TIA,
> > DejaVu
> >
> > --
> > DejaVu
> > ------------------------------------------------------------------------
> > DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
> > View this thread: http://www.excelforum.com/showthread...hreadid=479280
>
> --
>
> Dave Peterson
>