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?