I am trying to subtract hours from a time, but it's giving me strange results
A1 = 06:00:00 (manual entry, hours to deduct)
B1 = 00:30:00 (=C1-A1, start time)
C1 = 06:30:00 (manual entry, end time)
This works fine and continues to work as long as the difference is 6 hours or less.
Why do I get hashes in B1 if A1 is 07:00:00
for example, or if C1 is 05:00:00
?