Skip to main content
Windward

TIMESPAN Function

autotag-wiki-logo.pngOverview

The TIMESPAN function represents a time span.

For example,

=TIMESPAN(3,2,1)

represents a timespan of 3 hours, 2 minutes, and 1 second.

There is one major use:

  1. can be added to a time to provide an offset of a given number of hours, minutes, and/or seconds.  A time can be obtained using the TIME, DATA, and DATEDATA functions.

Syntax

TIMESPAN(hours,minutes,seconds)

  • hours - Required. The number of hours to span.
  • minutes - Required. The number of minutes to span.
  • seconds - Required. The number of seconds to span.
  • Was this article helpful?