You can use ROUND function.
select padr(cdow(datein),12) as DayIn, Round(Minutes/60,1) as TotHours from TimeCard
>Thank You Nadya,
>
>The day's are no longer truncated but its still displaying TotHours with 4 decimal places. But thats ok, its just minor - this project is kinda being rushed so I can fix that later.
>
>Thanks again!
>
>
select padr(cdow(datein),12) as DayIn, 00.00+Minutes/60 as TotHours from TimeCard
--sb--