Trying to add several numbers in the format ( STD . MIN ) The only formula I have come up with is for adding two numbers in that format. Formula
(INT(SUM(A1:A2))+INT(100*((A1-INT(A1))+(A2-INT(A2)))/60)+(MOD(100*(A1-INT(A14)+(A2-INT(A2)));60)/100))
any ideas.
[ 11 August 2001: Message edited by: Noted ]