Thread: MID formula, try to solve #VALUE! error

Originally Posted by Huron

You could use

=IF(C2=H$1,(E2-D2-F2)*24,IF(ISERROR(MID(C2,10,1)+0),0,(TRIM(MID(C2,10,2))+0)))

in column H

Hi Huron, YES you did make it just the way I wanted.
It could not be better for me!

Thank you very much.

Thanks to all of you replaying with your tips!! I try all of them but it didn't work for me.

Now you make my day it is time for report and I will used Huron code.