I've tried this and get -0.13

=IF(A2<"",(((TIME(LEFT(sheet1!K2,2),RIGHT(sheet1! K2,2),0)-TIME(LEFT(sheet1!J2,2),RIGHT(sheet1!J2,2),0))*24)) ,""




"Ardus Petus" wrote:

Try:
=(TIME(LEFT(K2,2),RIGHT(K2,2),0)-TIME(LEFT(J2,2),RIGHT(J2,2),0))*24

Cheers,
--
AP

"sedonovan" a écrit dans le message de
news: ...
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