I have a spreadsheet with 2 columns. The first column is the start time and
the second is the end time. They are shown in military time. I want to
calculate the difference between the two so I can get hours worked but when
the time overlaps days I get no result. For example if a worker started at
16:00 (4:00pm) and ended at 01:18 (1:18am) I get no result. Why is that? It
seems to work on calculations that do not overlap into the next day.