Ask the Community
Groups
How to See Time Entries in a Correct Format in Ad-Hoc BMS Reports? - Connect IT Community | Kaseya
<main> <article class="userContent"> <p><strong>Question: </strong>When I create an Ad-Hoc Report which user date and time components for example the "Time Entries" table, the "Start" and "End Time" formats are seen as <em><strong>Date</strong> </em>in the output instead of <em>Time</em>.</p> <p><strong>Resolution: </strong>This is happening because the cells for the time entries have not been set to indicate that this should be in time format.</p> <p><strong>Steps: </strong></p> <ol><li>Select the affected column, for this instance "Start/End Time" column. </li> <li> Right-click > Format > Date > choose any of the time formats. <ul><li> <strong>Note: </strong>If this is on an Express Report, click on the format icon:</li> </ul></li> </ol><p><img src="https://us.v-cdn.net/6032361/uploads/migrated/HSKXAFNTFJB9/mceclip1.png" alt="image" class="embedImage-img importedEmbed-img"></img><img src="https://us.v-cdn.net/6032361/uploads/migrated/EGGV4MZR2FMS/mceclip0.png" width="308" height="128" alt="image" class="embedImage-img importedEmbed-img"></img></p> <p><img src="https://us.v-cdn.net/6032361/uploads/migrated/A0ZYX404CR4L/mceclip2.png" alt="image" class="embedImage-img importedEmbed-img"></img></p> <p>3. Run the report - this should now show the entries in time format.</p> </article> </main>