General Advice - Timesheet application

So I have been tasked with converting a pilot timesheet application (written in Access) into an all singing all dancing web app. I'm planning on using SQL Server to provide some scale but wondered if anyone had any advice about processing time calcs.

I can of course use the smalldatetime datatype to store all the start at, finish at and elapsed hours times but wonderd if there was any comparative advantage to using numerics instead and converting to/from HH:MM representation.

Maybe I need to finally figure out how to create and use custom data types?

There's lots of math to do on these things once the data is captured for reporting and such and smalldattime looks like a fairly big waste of space for something that really only deals in hours.

Anyone doen things like this before? Any advice on what not to do?

many thanks

Steve1) Use datetime
2) If necessary, denormalize your datetime field converting them in several int fields. This method sometimes is used in DW environment (with a dimension time)

FULLTEXT SEARCH any drawbacks?

I need to know are there any disadvantages of using Full Text Search with MS SQL 2000. I'm planning to host my website to be developed in asp.net with shared hosting company. Taking this into consideration can there be any problems regarding Full Text Search.

Cheers
Luckyhi there,

there are none i suppose.. all i know is that full text search speeds up data retrieval process.. take a look at the link attached.. take care..

http://www.developer.com/db/article.php/3446891|||Thanks sashi
But I read it somewhere that it puts a lot of extra load on the server. Thats why most of the hosting companies do not provide this service.

Thanks again