How toFind the Time difference in hours

[Vimal]

How to find the difference between to dates with time in hours. For example
if my data in A1 is Wed 4/13/2008 12:00 PM and in B1 Thu 4/14/2008 3:00 PM i
want the difference as 27 hours.How to find this? Please some one help me out
in this

 

[Pete_UK]

Try this:

=(B1-A1)*24

Format cell as General or as Number.

Hope this helps.

Pete

 

[DFruge]

Format the cell of your result as follows by pressing Ctrl+1 to call up the
Format Cells dialog: in the Category list box, select Custom; and in the
Type text box, type [h]. Click the OK button. Now the result will be in
hours. Hope this helps.