Hi,

Forgive me for this question, but I'm having trouble controlling time inputs. So I use the code below to allow inputs in minutes, but (a) I'm wondering if someone has a better way? (b) having trouble with ignoring the conversion if it's already in HH:MM:SS format? This code doesn't work for (b) at all

If Not InStr(WorksheetFunction.Text(Target.Value, "[hh]:mm:ss;[hh]:mm:ss;#"), ":") Then Target.Value = Application.Evaluate("SUM(QUOTIENT(" & Target.Value & ",1)/60/24,MOD(" & Target.Value & ",1)*100/60/60/24)"): Application.ScreenUpdating = True: Application.ScreenUpdating = False