How I can do difference between two excel cells with customized formatting ?

[public]

Hello,

I want to make a difference between two cells (excel 2003 compatibility), each cell is formatted as follows:

12.10.2015 02:15
14.10.2015 16:45

where the date above is formatted like this: dd.mm.yyyy h:mm

I would like the difference between the two cells to be displayed as, eg. 48.5 hours (the word "hours" I will place it in an adjacent column).

Please!

[Pepe Le Mokko]

Perhaps =(A2-A1)*24&" hours" and format result as General

[public]

The above formula does not lead to the result that I wants to get it. Other ideas, please!

[FDibbins]

The above formula does not lead to the result that I wants to get it. Other ideas, please!

Can you explain why not?

Perhaps...

	B
1	10/12/2015 2:15
2	10/14/2015 16:45
3	62:30:00

B3=B2-B1
Formatted at Time and then use the setting tha shows 37:30:55

[HangMan]

Using FDibbins's image above try using the following in cell B3 or whichever cell you want to display the result.

Please Login or Register  to view this content.

The result will be 62.5 hours