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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks