Calculating number of hours accross 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?

Calculating number of hours accross days
 

=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?

Calculating number of hours accross days
 

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?

Calculating number of hours accross days
 

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?

Calculating number of hours accross days
 

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?

Calculating number of hours accross days
 

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?

Calculating number of hours accross days
 

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=572713