Thank you for your information. It sounds like you understand what I need. I will need to talk with someone at the host location in order to figure...

Thank you for your reply.

Both locations have SQL Server 2008 database. My location uses the BI tools SSRS, SSIS, SSAS.

Microsoft .NET framework.

What I need to do is create reports from...

Thank You!

Thank You very much!

Well, its weird actually the above format is not the cause. It seems to be only happening with a specific row or type of row. The logic is the...

Thanks.

Actually this is working but there was a change to the hours format and some hours have a 0 in front and some do not. ie 04:15 ...

Thanks.

Input from a database table:

WorkTimes

Hoursworked nvarchar(24) ( sample of hours:minutes data- 04:28)

create table #ExtraHoursRevised (

hoursworked datetime)

insert into #ExtraHoursRevised

select Hoursworked

from WorkTimes

I need the datetime definition...

Thank YOU!

Thank You!

Thanks!

Thank you. This works well it I disply seconds. The problem of rounding is still an issue. I do not want to have seconds and when I remove...

Thank You very much for the suggestions.

OK Thanks! I appreciate the information.