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]

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

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

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

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

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

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]

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

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.

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 neithe
of these is at the weekend

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

format as [h]:m