TIME Function (LibreOffice Calc)

• Builds a valid time from hour, minute, second
• Automatically normalizes overflow values
• Returns a fractional day (serial number)
• Works with any numeric inputs
• Ideal for constructing timestamps and cleaning data

It is designed to be robust, predictable, and essential for time‑based workflows.

TIME(hour; minute; second)

Arguments

• hour:
  Can be any integer (positive or negative).

• minute:
  Can overflow (e.g., 90 → +1 hour 30 minutes).

• second:
  Can overflow (e.g., 75 → +1 minute 15 seconds).

Construct 2:30 PM

=TIME(14; 30; 0)

Construct 8:45:12 AM

=TIME(8; 45; 12)

Midnight

=TIME(0; 0; 0)

Noon

=TIME(12; 0; 0)

75 minutes → 1 hour 15 minutes

=TIME(10; 75; 0)

Returns 11:15.

90 seconds → 1 minute 30 seconds

=TIME(9; 0; 90)

Returns 09:01:30.

Negative minutes

=TIME(10; -30; 0)

Returns 09:30.

Negative seconds

=TIME(10; 0; -30)

Returns 09:59:30.

Large hour values

=TIME(30; 0; 0)

Returns 06:00 (wraps after 24 hours).

Build a timestamp from components

=DATE(A1; B1; C1) + TIME(D1; E1; F1)

Add hours to a timestamp

=A1 + TIME(B1; 0; 0)

Add minutes to a timestamp

=A1 + TIME(0; B1; 0)

Add seconds to a timestamp

=A1 + TIME(0; 0; B1)

Convert H:M:S text to time

=TIME(VALUE(LEFT(A1;2)); VALUE(MID(A1;4;2)); VALUE(RIGHT(A1;2)))

Convert seconds to time

=TIME(0; 0; A1)

Convert minutes to time

=TIME(0; A1; 0)

Convert hours to time

=TIME(A1; 0; 0)

Build a time from decimal hours

=TIME(INT(A1); INT((A1-INT(A1))*60); ((A1*3600) MOD 60))

Build a time from milliseconds

=TIME(0; 0; A1/1000)

Combine date and time from separate cells

=A1 + TIME(HOUR(B1); MINUTE(B1); SECOND(B1))

TIME returns a fractional day (0–1)

Accepts:

• Any numeric values
• Negative values
• Overflow values

Invalid text → Err:502

TIME wraps hours beyond 24

TIME normalizes minutes and seconds

TIME ignores non-integer decimals in arguments

(Decimals are truncated)

TIME of an error → error propagates

• Use TIME to construct clean, normalized time values
• Use TIMEVALUE to convert text times
• Use TIME with DATE to build full timestamps
• Use TIME for adding hours/minutes/seconds
• Use TIME with VALUE to clean imported data
• Use TIME for converting raw seconds/minutes to time

• Use TIMEVALUE to convert text to time
• Use HOUR, MINUTE, SECOND for extraction
• Use NOW for dynamic date+time
• Use DATE for constructing dates
• Use VALUE to convert numeric text

By mastering TIME and its companion functions, you can build powerful, reliable, and fully normalized time‑based workflows in LibreOffice Calc.