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 tremendous. 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 take advantage of the identical method as above I get a unfavorable worth as a result of 01:31 is lower than 23:12. I attempted including 24h or 1d and so forth to that calculation, but it surely 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 may see, screwed up. I’ve tried altering the cells format from computerized to time or length, but it surely simply, robotically, reverts to computerized.
Including 24 is silly as a result of it requires me to manually try 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 top aim is to plot the values within the second column (12,3 and so forth) towards 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 forth. In different phrases, the space on the x-axis is irregular.
