<div>
Gosh - That's awesome - Thank you, 
 
This is what I ended up doing : but your way is best :) 
 
if datetimetoseconds({EntriesExits.Time}) &lt;&nbsp;3600 then '0:00' else if &nbsp;// 00:00 
 
&nbsp;(datetimetoseconds({EntriesExits.Time}) &gt;= 3600 and 
&nbsp; datetimetoseconds({EntriesExits.Time}) &lt;&nbsp;7200 ) then '1:00' else if // 01:00 
 
&nbsp;(datetimetoseconds({EntriesExits.Time}) &gt;= 7200 and 
&nbsp; datetimetoseconds({EntriesExits.Time}) &lt;&nbsp;10800 ) then '2:00'else if // 02:00 
 
(datetimetoseconds({EntriesExits.Time}) &gt;= 10800 and 
&nbsp; datetimetoseconds({EntriesExits.Time}) &lt;&nbsp;14400 ) then '3:00'else if // 03:00
</div>

Gosh - That's awesome - Thank you,

This is what I ended up doing : but your way is best :)

if datetimetoseconds({EntriesExits.Time}) < 3600 then '0:00' else if  // 00:00

 (datetimetoseconds({EntriesExits.Time}) >= 3600 and
  datetimetoseconds({EntriesExits.Time}) < 7200 ) then '1:00' else if // 01:00

 (datetimetoseconds({EntriesExits.Time}) >= 7200 and
  datetimetoseconds({EntriesExits.Time}) < 10800 ) then '2:00'else if // 02:00

(datetimetoseconds({EntriesExits.Time}) >= 10800 and
  datetimetoseconds({EntriesExits.Time}) < 14400 ) then '3:00'else if // 03:00

<div>
Easier would have been 
 
datetimetoseconds({EntriesExits.Time}) \ 3600 
 
Or 
 
Truncate(datetimetoseconds({EntriesExits.Time}) \ 3600) 
 
mlmcc
</div>

Easier would have been

datetimetoseconds({EntriesExits.Time}) \ 3600

Or

Truncate(datetimetoseconds({EntriesExits.Time}) \ 3600)

mlmcc

<div>
<div class="content wysiwyg-content">
I am using 'In Last full week Parameters', and then have my data {datetime} Grouped Hourly. The weekdays are rows and the Hourly 0-24 are columns but I am having trouble to only show 24 * hourly columns - Instead I see 0-24 Hrs for each day as my columns. (lots of columns)
</div>
</div>

I am using 'In Last full week Parameters', and then have my data {datetime} Grouped Hourly. The weekdays are rows and the Hourly 0-24 are columns but I am having trouble to only show 24 * hourly columns - Instead I see 0-24 Hrs for each day as my columns. (lots of columns)

CrossTab 'In last week' only needs to show 24 Hrs.

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.