I put 1830 in A2 and 1700 in A1:

And this formula in A3:
=(TEXT(A2,"00\:00")-TEXT(A1,"00\:00"))*24

And I formatted A3 as General.

sedonovan wrote:

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

--

Dave Peterson