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
| Row | A |
|---|---|
| 6 | Input |
| 7 | 12:00 PM |
| 8 | 6:00 AM |
| 9 | 6:00 PM |
Record 1
=TIMEVALUE(A7)Illustrative output0.5
See the inputs and instructions for all 3 examplesCopyable 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 |