I’ve this desk in Numbers:
Within the first column I need to calculate the variations between the timestamps within the third column. The primary 4 entries within the first column are superb. I simply subtract the earlier row from the present row (e.g., =C3-C2), however that does not work when going previous midnight between row 4 and 5. If I exploit the identical components as above I get a unfavourable worth as a result of 01:31 is lower than 23:12. I attempted including 24h or 1d and so on to that calculation, nevertheless it returned surprising outcomes.
If I used DUR2HOURS, as seen within the screenshot, I can add 24 and get a legitimate outcome however as an alternative the quantity format within the cell is, as you’ll be able to see, screwed up. I’ve tried altering the cells format from computerized to time or length, nevertheless it simply, robotically, reverts to computerized.
Including 24 is silly as a result of it requires me to manually do this for each midnight within the desk.
How do I deal with midnight in addition to repair the format of the time distinction within the first column?
The tip purpose is to plot the values within the second column (12,3 and so on) in opposition to the their “relative” timestamp. That’s, 12,3 begins at zero on the x-axis, the primary 12,7 at 3h 41m on the x-axis, the second 12,7 at 4h 08m (3h41m + 27m) on the x-axis and so on. In different phrases, the space on the x-axis is irregular.