Forum Discussion

Copper Contributor

May 17, 2023

Solved

#Value error when using =TimeValue() formula

In column 1, i have cells containing a date-time value (e.g. 01/01/2023 13:09:22). In column 2, i want to extract the time value and it is recommended to use =TimeValue() formula but i get a #VALUE error

What am i doing wrong?

excel

Excel on Mac

Formulas and Functions

Lorenzo
May 17, 2023
Hi DrJrz

The TIMEVALUE function expects a time value in a text form, ex: =TIMEVALUE("11:20:30")
Assuming your DateTime value is in A1, in any other cell: =MOD(A1,1) then format the cell as hh:mm:ss

1 Reply

Lorenzo
Silver Contributor
May 17, 2023
Hi DrJrz

The TIMEVALUE function expects a time value in a text form, ex: =TIMEVALUE("11:20:30")
Assuming your DateTime value is in A1, in any other cell: =MOD(A1,1) then format the cell as hh:mm:ss