Thread: time question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sedonovan
 
Posts: n/a
Default time question

i need to find the difference in two times - displayed as a decimal - eg 1700
- 1830 = 1.5

so far my formula is:

=IF(A2<"",TEXT(sheet1!K2)-(sheet1!J2)"h:mm","")

where am i going wrong?

cheers