i think you mistyped an extra comma:

ROUNDUP(MATCH(C3,B17:B100)/60,1)+4.5


--


Gary Keramidas
Excel 2003


"Teethless mama" wrote in message
...
Try this:

=ROUNDUP(MATCH(C3,B17:B100,)/60,1)+4.5



"wicket_wm" wrote:

I need a formula to calculate the following information please: I will
have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone
have a
simple formula I can do for this please?