How toFind the Time difference in hours

V

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top