I'm trying to make a spreadsheet to estimate my weekly pay check. I'm force to enter the time firstly as 24-hour time (as in 3 pm is entered as 1500 hrs; which I prefer to do) and secondly, if the end of my shift is at 3 pm, I have to enter it as 15:, then it will go in the cell.

I want to create a VBA program that, when I put in 1500, it'll know that it 15:00.

Attached is the spreadsheet that I have created


_______________________
Peter A.
Nickels
http://www.freewebs.com/rockyandnickels/
http://www.myspace.com/rockyandnickels/