Jump to content

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

Recommended Posts

  • Newbies
Posted

I have a calculation field that I want the result is time. I have an ID number for each record, I want the calculation to take the ID number, look at the last digit and put in a time in this field dependant on the last digit. In my calculation I have:

Case(Middle(ClassID, 6, 1)=1, "10:00",

Middle(ClassID, 6, 1)=2, "1:00",

.

.

.)

This works if the result is text. As time I get unusual results. A time value is entered by the values are extremely off and there appears to be no pattern as to the time difference. I have tried entering the time in different formats; hh:mm:ss, hh:mm, military time, with and without am/pm, all with no success. What am I doing wrong?

Thanks,

Nick Trenary

Cedar Rapids Public Library

Posted

Time( Choose( Middle( ClassID, 6, 1 ) - 1, 10, 1, ... ), 0, 0 )

If 1 is 1 pm, use 13 instead of the 1 following 10.

This topic is 7438 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.