Jump to content

This topic is 5507 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

  • 2 weeks later...

This topic is 5507 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.