I have a bit of an unusual situation here trying to calculate time between 2 values. Two fields are present(start and end time) are in HHMM format. So, the hours can be between 00 and 24 and the minutes between 00 and 59. Potnetially an example would be 0330 and 2424.
Perhaps I need to do some formatting before that calculation, which I don't mind doing, but I am unsure how to approach this. I appreciate any ideas.