If you have always got four digits, then you can convert each into a
time with the following:

=VALUE(LEFT(A1,2)&":"&RIGHT(A1,2)&":00"), and
=VALUE(LEFT(B1,2)&":"&RIGHT(B1,2)&":00")

Format them as Time. So, if you just want the difference in minutes
then:

=VALUE(LEFT(B1,2)&":"&RIGHT(B1,2)&":00")-
VALUE(LEFT(A1,2)&":"&RIGHT(A1,2)&":00")

and format as [mm]:ss (assumes B1 is a later time than A1).

Hope this helps.

Pete

On May 3, 4:25 pm, Stan Halls
wrote:
Help
I have 2 columns both with 4 digits as a time 1341 1415 . thease
fields are brought in from another system and can not be changed to a time
format what i am trying to do is work out the difference if it takes away
1341 from 1415 as a time rather than a number, so i get 34 as the result
instead of 74 as i get at present.

Thank you in advance for help

Stan