Calculating number of hours accross days

[MTLeslie]

Hello

I need help calculating aging in hours across multiple days.

For the example below, how would I calculate the number of hours between the
start date and end date?

Thanks

Start Date = 8/11/2006 5:05
End Date = 8/14/2006 17:58

How do I calculate the number of hours between start and end date?

[Toppers]

=Endate - Startdate and format cell as [hh]:mm

"MTLeslie" wrote:

> Hello
>
> I need help calculating aging in hours across multiple days.
>
> For the example below, how would I calculate the number of hours between the
> start date and end date?
>
> Thanks
>
> Start Date = 8/11/2006 5:05
> End Date = 8/14/2006 17:58
>
> How do I calculate the number of hours between start and end date?

[MTLeslie]

Hello Toppers

I do not have the option to format the cell as [hh]:mm. Under the "Custom
Category", I have the option to format as h:mm. However, this format does
not account for the hours across days.

Thanks

"Toppers" wrote:

> =Endate - Startdate and format cell as [hh]:mm
>
> "MTLeslie" wrote:
>
> > Hello
> >
> > I need help calculating aging in hours across multiple days.
> >
> > For the example below, how would I calculate the number of hours between the
> > start date and end date?
> >
> > Thanks
> >
> > Start Date = 8/11/2006 5:05
> > End Date = 8/14/2006 17:58
> >
> > How do I calculate the number of hours between start and end date?

[Toppers]

In the Custome Categorry, type "[hh]:mm" (no quotes) in the "Type:" entry
box; this will create a new Custom format. Use this for your cell formatting.

Click OK.

HTH

"MTLeslie" wrote:

> Hello Toppers
>
> I do not have the option to format the cell as [hh]:mm. Under the "Custom
> Category", I have the option to format as h:mm. However, this format does
> not account for the hours across days.
>
> Thanks
>
> "Toppers" wrote:
>
> > =Endate - Startdate and format cell as [hh]:mm
> >
> > "MTLeslie" wrote:
> >
> > > Hello
> > >
> > > I need help calculating aging in hours across multiple days.
> > >
> > > For the example below, how would I calculate the number of hours between the
> > > start date and end date?
> > >
> > > Thanks
> > >
> > > Start Date = 8/11/2006 5:05
> > > End Date = 8/14/2006 17:58
> > >
> > > How do I calculate the number of hours between start and end date?

[Sloth]

You can get decimal hours (84.88 in the example you gave) by using the
following formula

=24*(A2-A1)

and formatting the cell as a number (it might try and show as a funny date
before you change the formatting).

You can get the time in excell time (84:53 in the example you gave) by using
the following formula

=A2-A1

and using a custom number format of as Toppers said.
[h]:mm

you can type in your own format by clicking on "custom" under "Category "
and typing the format under "Type:". By adding the brackets, the result will
account for the time across days.

"MTLeslie" wrote:

> Hello
>
> I need help calculating aging in hours across multiple days.
>
> For the example below, how would I calculate the number of hours between the
> start date and end date?
>
> Thanks
>
> Start Date = 8/11/2006 5:05
> End Date = 8/14/2006 17:58
>
> How do I calculate the number of hours between start and end date?

[MTLeslie]

Thanks! You guys rock!!

Now for extra credit......

Start Date = 8/18/2006 6:36
End Date = 8/22/2006 14:32

If I did not want to include weekend hours, is there a way to exclude these
hours (other than subtracting 48 hours). Similar to the NETWORKDAYS
function, except I want hours, not days. There needs to be a NETWORKHOURS
function!!!

Matt

"Sloth" wrote:

> You can get decimal hours (84.88 in the example you gave) by using the
> following formula
>
> =24*(A2-A1)
>
> and formatting the cell as a number (it might try and show as a funny date
> before you change the formatting).
>
> You can get the time in excell time (84:53 in the example you gave) by using
> the following formula
>
> =A2-A1
>
> and using a custom number format of as Toppers said.
> [h]:mm
>
> you can type in your own format by clicking on "custom" under "Category "
> and typing the format under "Type:". By adding the brackets, the result will
> account for the time across days.
>
> "MTLeslie" wrote:
>
> > Hello
> >
> > I need help calculating aging in hours across multiple days.
> >
> > For the example below, how would I calculate the number of hours between the
> > start date and end date?
> >
> > Thanks
> >
> > Start Date = 8/11/2006 5:05
> > End Date = 8/14/2006 17:58
> >
> > How do I calculate the number of hours between start and end date?

[daddylonglegs]

To exclude weekend hours

If the start date/time is in A1 and end/date time is in B1 and neither of these is at the weekend

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

format as [h]:mm