Thanks for that, Ron.

And your formula was more elegant than mine, too. <bg

Pete

On Nov 13, 12:46*am, Ron Rosenfeld wrote:
On Thu, 12 Nov 2009 15:42:27 -0800 (PST), Pete_UK wrote:
I'm assuming from your example that EST is GMT-7.

EST (Eastern Standard Time) is GMT-5, Pete.

I ASSumed that the time in A1 was CST (Central Standard Time in the US)

GMT-7 would be MST in the US (Mountain Standard Time)
--ron