Solved: Macro inserting colon in time returning #value! in output column

[Barryj]

I have a macro in the attached workbook which inserts a colon when a user inserts a time.

In the hours column it should add up the difference between the two times inserted in columns E & H.

All cells in the range are formatted as hh:mm but it is showing #value! in the hours column instead of the time.

can anyone provide any info as to why it would be giving this result, is it a formatting issue or is there other issues that might be causing this problem.

Any advice appreciated.

[p45cal]

leading space in times, change to:
NewInput = Left(UserInput, Len(UserInput) - 2) & ":" & Right(UserInput, 2)

[Barryj]

Thanks p45cal that has rectified the problem, much appreciated.