I have a spread sheet for tracking employees time and for some days the
fields are displayed correct but in others (using the same format) the hours
are out of whack!
For example:
Cell d7 = 19:30 e7 = 05:30 (should be 10 hours)
Cell d6 = 10:00 e6 = 20:00 (should be 10 hours)
Cell d5 = 05:30 d5 = 15:30 (should be 10 hours)

When I add the totals together it shows 6:30 hours, I've tried several
different formulas from this website and none of them work on this particular
problem.
My spreadsheet uses 2 colums per employee per day (start & end) times. It
starts in column B and ends in column O (7 days for the week).

It seems that if the total number of hours for the above 3 employees exceeds
24 hours then the time gets messed up.

Any ideas?