Thread
:
time question
View Single Post
#
1
Posted to microsoft.public.excel.misc
sedonovan
Posts: n/a
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
Reply With Quote