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

Try this:

=(B1-A1)*24

Format cell as General or as Number.

Hope this helps.

Pete

On Apr 28, 2:41*pm, Vimal wrote:
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

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.

--
Daniel Fruge

"Vimal" wrote in message
...
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