Forum Discussion
Mich8261
Feb 21, 2024Copper Contributor
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...
HansVogelaar
Feb 21, 2024MVP
bear62
Aug 04, 2025Copper Contributor
The issue I have using this is; if K7 is blank for any reason, the formula returns a #VALUE error.