Thanks Tony,

Worked a charm.

I have another question:

How do I calculate the number of days hours minutes and seconds between 2 date & time ranges.

EG.

A1 = 12/10/11 B1 = 13:56:30
A2 = 19/11/11 B2 = 9:45:00

I want it to display the aswer in number format (eg 12.66 days)