In any case, blood in the dog's stool should not be taken lightly and you should always take him or her to the vet as soon as possible. In the meantime, you can feed them white rice with a little garlic or garlic powder mixed in, boiled potatoes, green beans, or a little boiled chicken. When there is blood in a dog's stool. Yeah, it can be quite a scare, but when there is blood in a dog's stool and it doesn't always mean a trip to the emergency clinic.
If that's a valid date/time entry then excel simply stores it as a number (days are integers and the time is the decimal part) so you can do a simple subtraction. I'm not sure if 7/6 is 7th June or 6th July, assuming the latter then it's a future date so you can get the difference in days with. =INT(A1-TODAY()).
In the example above, the date and time in cell B1 is internally represented by the number, 40562.875 and the date and time in cell B2 is internally represented by the number 40564.625. Subtracting these two numbers gives the result 1.75 which is Excel's internal representation for 42 hours 0 minutes.ell B3 of the following spreadsheet shows a simple example of how to calculate a time difference in Excel. The calculation simply subtracts the time in cell B1 from the time in cell B2.