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