TIME Function

Builds a time from hours, minutes and seconds.

Category

Date & Time

Available in

All versions, Microsoft 365

Returns

A time (fraction of a day)

Want to practice TIME in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

TIME turns hours, minutes and seconds into a time Excel can calculate with.

Excel stores a time as a fraction of a day: 0.5 is noon, 0.75 is 6:00 PM. A date with a time is the date's whole number plus that fraction.

Syntax

=TIME(hour, minute, second) Explain

Arguments

ArgumentRequired?What it does
hourYes0–23. Larger numbers wrap around the clock (27 becomes 3:00 AM).
minuteYesMinutes. 90 becomes 1 hour 30 minutes.
secondYesSeconds.

Examples

Example 1 — Shift start times

The rota stores hours, minutes and seconds in separate columns.

D2fx=TIME(A2,B2,C2)
ABCD
1HourMinuteSecondTime
293009:30 AM
3141502:15 PM
41745305:45:30 PM
=TIME(A2,B2,C2) Explain

Example 2 — Adding minutes to a time

Meeting end times from a start time and a length in minutes.

C2fx=A2+TIME(0,B2,0)
ABC
1StartsMinutesEnds
29:00 AM9010:30 AM
31:45 PM302:15 PM
=A2+TIME(0,B2,0) Explain

Common mistakes

  • TIME(25,0,0) shows 1:00 AM. TIME wraps past midnight. For durations longer than a day, add hours/24 instead, and format as [h]:mm.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.