The first thing to do is to get into units of half an hour. As you know,
multiplying by 24 gets it into units of 1 hours, so multiplying by 48 gets
it in units of half an hour (such as 7.326 half hours).

Rounding this up to 0 decimal places gets us an integer number of half hour
units.

Dividing by 2 gets it back into hour units.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul Cooke" wrote
in message ...

Hi Bob,

Many thanks for your prompt reply, it works perfectly, only if you have
the time could you explain how you did it so i can undersatand for the
future

Many thanks again

Regards

Paul


--
Paul Cooke
------------------------------------------------------------------------
Paul Cooke's Profile:
http://www.excelforum.com/member.php...o&userid=29268
View this thread: http://www.excelforum.com/showthread...hreadid=489876