View Single Post
  #1  
Old June 2nd, 2010, 03:53 PM posted to microsoft.public.excel.worksheet.functions
Radhakant Panigrahi
external usenet poster
 
Posts: 43
Default difference between two time

Hi,

i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to
calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is
not coming only A1-B1 is coming which is +ve 2.30 hrs

can anybody help me.

regards,
radha