[Dropped] Cells with time show a negative value

[Gibbanator]

Edit: Split from How to sum range of time? since new person needs new topic.

Then if you see -632 hours, it is most probably because one of the time in the row above is not on the same day as the others. Use the same format on each row for the cells that represent the total time per day, and let us know which formula you used to calculate the 8 hours per day, may be there is something wrong in it. Format your cells as numbers to see the exact content.

Or attach a copy of your file (use the tab "Upload Attachment" just below the "Submit" button when you create a post.

So this does not work. I am having same problem as Markmont. If I change all the cells to the same format then each of them show a minus number for the time like this: https：//i.gyazo.com/90c7a59e8489309e796777b01acfdc26.png.

J0.png (10.36 KiB) Viewed 1625 times

Here is the format used: https：//i.gyazo.com/2e4e1cc7f6d17c07cb88a869da715ba4.png

and this is what it looks like when I change them all to the format you suggest: https：//i.gyazo.com/3766f7d47f27619f5cd627e31700b7cf.png.

If I use the normal format HH:MM:SS they show correct. Only the Total w/Lime total will not add over 24 hours. Dragging my file here does not load it and I do not see a place to load it.

[robleyd]

See How to attach a document for details regarding attaching a document.

[RusselB]

The negative numbers are occurring due to the fact that the system isn't seeing a difference in date.
If you go from 2:00 pm to 1:00 am, and don't specify the dates, the system presumes that the date portion for both times is the same, thus you get a negative number of hours.
You know that's not possible (time travelers excluded), but the computer doesn't.
Simply include a date portion along with the time and your numbers should work correctly.

[Villeroy]

=end-start+(end<start)
adds one day if the end time is smaller than the start time.