Hi, i was wondering if it is possible to remove the date value within a date/time value. I know how to do this with the date value:
=DATEVALUE(MONTH(A1) & "/" & DAY(A1) & "/" & YEAR(A1))
but tried using the following for TIME but this does not work.
=TIMEVALUE(HH(A1) & ":" & MM(A1) & ":" & SS(A1))
Hope that makes.
Thanks in advance.
Bookmarks