Thanks.

I already have a date in a different column and I trying to calculate the number of minutes worked by an employee on a given date. I have the starttime as 80010 (integer) and endtime as 161500. The result I am looking for is 495 minutes. I believe I can achieve this result if I was able to convert startdate 80010 to 08:00:10 and endate to 16:15:00 and then using the datediff function to get the results in minutes.:-)