I an creating a TimeSheet table, but have a question.

If i set the start/finish time fields as TimeStamp, and use the DropDown Calendar, a Calc field set to Number, gives me the correct hours between the start and finish times[(Finish-Start)/3600].

However, as the Dropdown calendar exits the field when a date is selected, i need to re-select the field to manually enter the time.

Is there a way to use a number field to enter the time as (0700 & 1500 etc) instead of having to re-select, and utilize a date in another field?

If i choose a edit box instead of the dropdown calendar, i get a revert field alert, as there was no date entered.

I am after a solution that a 24hour is manually entered, and the hour difference is calculated, but allows for the opportunity to enter a date if the hours run over between 2 days.

perhaps add a script trigger to the field, and edit the value to what you want after exit?

How do i go about setting up a script trigger?

I have not dealt with them before.