ExcelFlux

TIMEVALUE function

Conversion — a time in the form of text to a serial number.

Date and time · Guided Excel example

Where can you use it?

Planning and operations teams. Use this group to work with dates and times in calendars, delivery schedules, shifts and period reporting.

Scenario in the workbook

Convert clock text into fractions of a day. The examples use 12-hour notation.

A worked example from the workbook

RowA
6Input
712:00 PM
86:00 AM
96:00 PM
Record 1
=TIMEVALUE(A7)

Illustrative output0.5

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=TIMEVALUE("12:00")
Turkish Excel · tr-TR
=ZAMANSAYISI("12:00")

Expected result

0.5

Worked examples

Convert clock text into fractions of a day. The examples use 12-hour notation.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A
6 Input
7 12:00 PM
8 6:00 AM
9 6:00 PM
Trial Expression Sample output
Record 1 =TIMEVALUE(A7) 0.5
Record 2 =TIMEVALUE(A8) 0.25
Record 3 =TIMEVALUE(A9) 0.75
Microsoft Excel reference