Subtracting dates
 

Is there a way to subtract 2 dtes and have the result come out in hours?
I am looking for a way to show the time difference between dates but it has
to be show in hours. I have tried formating the cell after doing this
subtraction but this wont work.
Thanks in Advance.

Subtracting dates
 

To get a result in decimal hours (ie. 35.25 equals 35 hours and 15 minutes):
=24(A2-A1)
format the cell as a number.

To get a result in Excel time (ie. 35:15):
=A2-A1
format the cell like this...
[h]:mm


"toot033" wrote:

Is there a way to subtract 2 dtes and have the result come out in hours?
I am looking for a way to show the time difference between dates but it has
to be show in hours. I have tried formating the cell after doing this
subtraction but this wont work.
Thanks in Advance.

Subtracting dates
 

typo!
=24*(A2-A1)

Cheers,
--
AP

"Sloth" a écrit dans le message de news:
...
To get a result in decimal hours (ie. 35.25 equals 35 hours and 15
minutes):
=24(A2-A1)
format the cell as a number.

To get a result in Excel time (ie. 35:15):
=A2-A1
format the cell like this...
[h]:mm


"toot033" wrote:

Is there a way to subtract 2 dtes and have the result come out in hours?
I am looking for a way to show the time difference between dates but it
has
to be show in hours. I have tried formating the cell after doing this
subtraction but this wont work.
Thanks in Advance.

Subtracting dates
 

oops. Good eye Ardus

"Ardus Petus" wrote:

typo!
=24*(A2-A1)

Cheers,
--
AP

"Sloth" a écrit dans le message de news:
...
To get a result in decimal hours (ie. 35.25 equals 35 hours and 15
minutes):
=24(A2-A1)
format the cell as a number.

To get a result in Excel time (ie. 35:15):
=A2-A1
format the cell like this...
[h]:mm


"toot033" wrote:

Is there a way to subtract 2 dtes and have the result come out in hours?
I am looking for a way to show the time difference between dates but it
has
to be show in hours. I have tried formating the cell after doing this
subtraction but this wont work.
Thanks in Advance.