Icarus. Thanks for the reply. You are correct, it is supposed to be (a1-INT(a1).
I have the predicted flight hours in the format ( hh . mm ) and not in the standard format of ( hh : mm ), that's what makes it a bit difficult and that's the reason for the formula. It is about 20 flight legs that I'm trying to add. At the moment the formula looks something like this:
=(INT(SUM(D4
23))+INT(100*((D4-INT(D4))+(D6-INT(D6))+(D7-INT(D7))+(D8-INT(D8))+(D9-INT(D9))+(D10-INT(D10))+(D11-INT(D11 ))+(D12-INT(D12))+(D13-INT(D13)))/60)+(MOD(100*(D4-INT(D4)+(D6-INT(D6)+(D7-INT(D7)+(D8-INT(D8)+(D9-INT(D9)+(D10-INT(D10) +(D11-INT(D11)+(D12-INT(D12)+(D13-INT(D13))))))))));60)/100))
I am sure there is an easier way, just have not found it yet.
[ 12 August 2001: Message edited by: Noted ]
[ 12 August 2001: Message edited by: Noted ]