Hello plettieri
I'm afraid that i need to do it in a macro only (now i use formulas in the worksheet)
so i can use the function in other workbooks.
i tried the following line in vb:
f=formatdatetime(date2-date1,vbshorttime)
and then i got the difference in time format (00:30) but how can i convert the time value to integer (0.5)?
Thanks
Rafael