Once you have calculated the time difference, you can right-click on it, and then select Format. Then set the display time in 24 hrs format. However, if you calculate the time difference in number format, it will work differently i.e, 12:00 PM will be calculated to 0.05 because it's half of a day.