Audimation Services has been acquired by CaseWare International Learn More.

X
Icon


Blog Image

Tech Tip: Timekeeping Analysis


A common question of late has had to do with calculating time passed, example – hours and minutes worked. There are two built in IDEA functions – rarely used, often forgotten.

@Tton – Converts a Time field that has values stored in Time format (HH:MM:SS) to a Numeric field with the time value converted into seconds. This is the reverse of @Ntot.

@Ntot – Converts a Numeric field containing time stored as seconds to a Time field type with a Time format (HH:MM:SS).

Using SAMPLE-WEBLOG.IMD file from SAMPLES project installed with IDEA.

  1. APPEND FIELD: SECONDS
    1. Type: Numeric
    2. Size: 0 decimal places
    3. Parameter: @TtoN( TIME )
    4. Description: Time converted to seconds
  2. SUMMARIZE file
  3. APPEND FIELD: TIME_PASSED
    1. Type: TIME
    2. Size: N/A
    3. Parameter: @Ntot( SECONDS_SUM )
    4. Description: Seconds converted to time format

 


Best Practices , CaseWare IDEA , Tech Tip



Posted By

By Kris Willison
Kris joined the Professional Services team in January of 2015 as a Solutions Specialist. She has an extensive background in Software and Database Development accumulated from thirty years in IT support with twenty years’ experience in database development, cleanup, audit and migration using Microsoft Access. In her time with Audimation, she has received client praise for her “Top Tier” engagement on Monitor and Scripting projects. Kris enjoys looking at problems from new angles to determine the most efficient means of meeting the clients’ needs. Kris has been breeding/showing purebred Balinese cats since 1972 and Oriental Longhairs since 1996. She also hosts one of the largest online pedigree database sites for Siamese and related breeds with nearly 600 users worldwide.


Related Posts
Tech Issues: Data Analytics Locks in Relevance
Nov 11 As a CPA, you’ve always been the one who can pick the relevant data out of an array of long columns and rows. These days, however, the amount of data collecte...
Tech Tip: Report Reader Menu (Customize)
Jul 21 I had much sympathy for a recent caller to our help desk complaining about the size of the icons on the Report Reader ribbon. I make it a habit of using my 24...
Removing Language Barriers in Data Analytics
Nov 08 Recently, the Solutions Development department at Audimation took on a project with a major client who needed to analyze data from the Asia Pacific area for red...
BROWSER NOT SUPPORTED

This website has been designed for modern browsers. Please update. Update my browser now

×