I didn't deal with possibility of times crossing midnight, and I only
just noticed the part of your formula saying End of Day.

Amend the formula to
=IF(MOD(H8-$H$7,1)0.5,"End of Day",
H8+INDEX($O$21:$O40,INT((MOD(H8-H7,1))*24)))

--
Regards

Roger Govier


"Roger Govier" wrote in message
...
Hi

Could you not use
=H8+INDEX($O$21:$O40,INT((H8-$H$7)*24))

--
Regards

Roger Govier


"sharmashanu" wrote in message
ps.com...
can you tell me the format of that function
tx