Newbies lemmas Posted October 19, 2004 Newbies Posted October 19, 2004 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
-Queue- Posted October 19, 2004 Posted October 19, 2004 Time( Choose( Middle( ClassID, 6, 1 ) - 1, 10, 1, ... ), 0, 0 ) If 1 is 1 pm, use 13 instead of the 1 following 10.
Newbies lemmas Posted October 19, 2004 Author Newbies Posted October 19, 2004 Ah, yes. That did it. Thanks -Queue-!
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now