About This Document
The Gnumeric Manual, version 1.8
- Welcome!
- How to Use this Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- Graphics: Plots, Images, Widgets, and Drawings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
    
    DATE
    
    DATE2UNIX
    
    DATEDIF
    
    DATEVALUE
    
    DAY
    
    DAYS360
    
    EDATE
    
    EOMONTH
    
    HOUR
    
    ISOWEEKNUM
    
    ISOYEAR
    
    MINUTE
    
    MONTH
    
    NETWORKDAYS
    
    NOW
    
    SECOND
    
    TIME
    
    TIMEVALUE
    
    TODAY
    
    UNIX2DATE
    
    WEEKDAY
    
    WEEKNUM
    
    WORKDAY
    
    YEAR
    
    YEARFRAC
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
  - Number Theory
  - Random Numbers
  - Statistics
  - String
- Keybinding Reference

TIME

The Gnumeric Manual, version 1.8
Function Reference
Date/Time

TIME —

Synopsis
Description
Examples
See also

Synopsis

TIME (hours,minutes,seconds)

Description

TIME returns a fraction representing the time of day.

This function is Excel compatible.

Examples

TIME(3, 5, 23) equals 3:05AM.

See also