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