Forum Discussion
Converting number to time
I am trying to automate the conversion of a data point, which is supposed to capture the hour and minutes an action takes place. The data entry is meant to capture HH:MM but on the Excel file it come...
The issue I have using this is; if K7 is blank for any reason, the formula returns a #VALUE error.
You can use
=IF(K7="", "", TIMEVALUE(TEXT(K7, "00\:00")))
or
=IFERROR(TIMEVALUE(TEXT(K7, "00\:00")), "")