I use the following formula to convert a String Time field to HH:MM pretty successfully; but it is not working today on a field and I'm looking for help.
Field is: JT_DailyTimeEntry.StartTime It is a 4-digit String Field. Formula that has worked for me before is here. The formula is returning a time, but it is wrong. Maybe something with the field and how it is in Operations Management? I don't know. Any suggestions or advice?
ctime(cdbl({FieldNameHere})/24)
------------------------------
Madeline Stefanou
RKL eSolutions, LLC
------------------------------