Calculate the time between two dates

how to calculate the days, hours, minutes, seconds between two dates?

Use a typical table:

• excel
• google sheets
• Open Office
• etc.

Enter the two dates for example in C2 the date of departure and in C3 the end date

to calculate the days it is enough to make a subtraction of the two dates: C3-C2 or otherwise to use the function days () in English or dates () in English version.


For hours, minutes, and seconds, rather than going into calculations, you just have to right-click on the cell and choose the display format. Under Excel, apply the subtraction of the two dates:

choose the 'custom' format then:

• [hh]: for hours
• [mm]: for the minutes
• [ss]: for seconds