Skip to content

TIMESPAN

Usage

Create a timespan of a given value

Category Function Type Where to use Argument statement
FUNCTION SERVER ROW TIMESPAN .VALUE

Syntax

1
=TIMESPAN(d, h, m, s)

Arguments:

d
Days

h
Hours

m
Minutes

s
Seconds

Warning

Anything different from a valid number will not be considered

Return Value

Integer

Examples

Example 1

Formula
=TIMESPAN(1; 10; 10; 15)

Description
Create a timespan from the given value

Result
1 (days) 10 (hours) 10 (minutes) 15 (seconds)