View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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?