TIMING Command

The SQL*Plus TIMING command displays output in hours, minutes, seconds and hundredths of seconds, for example, 02:31:07.55, which is 2 hours, 31 minutes and 7.55 seconds.

See "Collecting Timing Statistics on Commands You Run" in Chapter 2 and the sections "SET" and "TIMING" in Chapter 8 of SQL*Plus User's Guide and Reference which discuss how to use the TIMING command and the SET TIMING command to record timing data for an elapsed period.