Hi Koot,

Based on your values, EndTime - StartTime will return 34200 which is the time difference expressed in seconds. To express it as 9.5 (which is the number of hours) you need to divide by 3600 (60 seconds * 60 minutes).

Eg (EndTime - StartTime) / 3600 = 9.5

Regards,

Liam



>Can any body help with the above for a timesheet input.
>eg.
>StartTime = 02/18/2003 07:00:00
>EndTime = 02/18/2003 16:30:00
>EndTime - StartTime = 9.50
>
>Thanx