Clicks Conversion

[John]

I have a table that give me time in clicks and I have a SQL statement that
converts it to normal time. For some reason it is outputting only the Hour
and not the min. This is what its outputting 8:

Here is the SQL statement. Any help would be great. Thanks!!


cast(cast(Truncate("- Timecard Basic Detail"."Employee Report To Work Actual
Time",0) as int) as char) || ':' || left(right(cast( ((("- Timecard Basic
Detail"."Employee Report To Work Actual Time" - Truncate("- Timecard Basic
Detail"."Employee Report To Work Actual Time",0))*60)+100) as char),5),2)

 

[John W. Vinson]

I have a table that give me time in clicks and I have a SQL statement that
converts it to normal time. For some reason it is outputting only the Hour
and not the min. This is what its outputting 8:

Here is the SQL statement. Any help would be great. Thanks!!


cast(cast(Truncate("- Timecard Basic Detail"."Employee Report To Work Actual
Time",0) as int) as char) || ':' || left(right(cast( ((("- Timecard Basic
Detail"."Employee Report To Work Actual Time" - Truncate("- Timecard Basic
Detail"."Employee Report To Work Actual Time",0))*60)+100) as char),5),2)

This is evidently T/SQL for a SQL Server database - not Access VBA, the
subject of this newsgroup. Are you sure you're asking in the right place?