Hours and minutes difference between two times in Excel

Question

I have two columns of data. The first one is sunset on a particular day X and the next column is a time a few hours later but on day X+1 (as at 00:00 day X+1 comes in). How can I calculate the number of hours between sunset on day X and the time in the second column which is just a few hours later but on day X+1?

The data is in hh:mm:ss format as below:

Answer 1

Using the TEXT function in Excel is another simple way to calculate the time difference between two dates: Calculate the number of hours between two dates: TEXT = (B2-A2, "h") Return the hours and minutes between the following two times: TEXT = (B2-A2, "h:mm") Between two times, return the hours, minutes, and seconds: TEXT = (B2-A2, "h:mm:ss")