This is what I have for the error:
Error: bad time format string
hoursIntoShift
{Claim.loss_time}: "12:00AM"
{CustomTable.time_formatted}:""
VAR TOS:#00:00:00#
VAR TOI: <null>
And here is my formula that I midified:
Local Timevar TOS := if isnull({Claim.loss_time}) then time(0,0,0) else
time(rtrim({Claim.loss_time}));
Local Timevar TOI := if isnull({CustomTable.time_formatted}) then time(0,0,0) else
time({CustomTable.time_formatted});
time(0,0,0) + ((TOS) - (TOI))
And here is the sample data:
Time_formatted:
CustomTable
| time_formatted |
| 9:00 AM |
| 9:00 AM |
| 8:00 AM |
| 8:00 AM |
| 8:00 AM |
| 7:00 AM |
| 6:00 PM |
| 6:00 PM |
| 6:00 AM |
| 6:00 AM |
| 6:00 AM |
| 6:00 AM |
| 4:15 AM |
| 4:00 PM |
| 4:00 AM |
| 22:00 PM |
| 22:00 PM |
| 2:00 PM |
| 2:00 PM |
| 2:00 AM |
| 2.00 PM |
| 19:00 PM |
| 12:00 PM |
| 12:00 PM |
| 12:00 PM |
| 12:00 AM |
| 12:00 AM |
| 12:00 AM |
| 11.00 AM |
| 10:25 AM |
| 10:00 PM |
| 10:00 AM |
| 1:00 PM |
| 1:00 AM |
| 1:00 AM |
loss_time:
Claim
| loss_time |
| 12:59PM |
| 12:59PM |
| 12:59PM |
| 12:59PM |
| 12:59PM |
| 12:58PM |
| 12:58PM |
| 12:58PM |
| 12:58PM |
| 12:58PM |
| 12:58PM |
| 12:58PM |
| 12:58AM |
| 12:58AM |
| 12:58AM |
| 12:58AM |
| 12:58AM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57PM |
| 12:57AM |
| 12:57AM |
| 12:57AM |
| 12:56AM |
| 12:56AM |
| 12:55PM |
| 12:55PM |
| 12:55PM |
| 12:55PM |
Thank you!