LinkBack URL
About LinkBacks
Markshr 
Hi all,
maybe in F24:
=SUMPRODUCT(--(ROUND($C$4:$C$52,5)=ROUND(F25,5)))
It's a rounding issue, these problems are derived from the transformation from decimal to sexagesimal notation of the time: double check this info.
Regards
Hi all,
maybe in F24:
=SUMPRODUCT(--(ROUND($C$4:$C$52,5)=ROUND(F25,5)))
It's a rounding issue, these problems are derived from the transformation from decimal to sexagesimal notation of the time: double check this info.
Regards
Last edited by canapone; 02-08-2012 at 02:04 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Brilliant, thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks