good morning,

i'm managing a worksheet that is organized as follows:

Columns A: Time
Cell B1: Default Time 9:10:00
Cell C1: Bin Time 00:05:00
Columns D: This formula(let's call time bin)
=CEILING(A2-$B$1;$B$1)/$B$1

I'd like to write a sub in vba that calculate the maximun whithin every
Time Bin.

thank you



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/