Hi,

I have entered all my times as xxxx now I want to be able to use them with a
date to calculate the difference between two dates and times so I have to
change all the times to xx:xx

example: 1200 needs to be 12:00 so I can go 5-jan-07 12:00 - 4-jan-07 8:00,
the times and dates are in different columns

Thanks for your help