I've not looked at your links, if its a follow on from that thread then
you should post in that thread so people can follow it easy, that said,
take a look at Chip Pearsons site it is well explained with working
examples 'Dates And Times In Excel'
(http://www.cpearson.com/excel/datetime.htm)

Andy;308505 Wrote:
Following on from here...
'Discussion Groups Home' (http://tinyurl.com/cskmr8)

I'm still struggling. I've uploaded a file here in anyone would be able
to
help further?

'Copy of NGH Ortho Ward Occupancy.xls' (http://tinyurl.com/cjpuxv)

Thanks in advance.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86244