When it comes down to it, it’s actually easy to calculate with dates. Let’s say you were born on 01.07.1985 and would like to know how many days you are old. Then enter the first cell 01.07.1985 and in the second cell the current date bsp. 06.11.2019.

Then you only have to subtract the smaller date (01.07.1985) from the larger one (06.11.2019) in the result cell. Or you use the function = DAYS(   in the result cell (the result is 12,546 days in both cases).

See picture (click to enlarge)

Likewise, you can work on this way, of course, only with times.

Of course, to combine the date and time to present a result works well. Let’s take our example to hand again and just say you were born on 01.07.1985 at 8:00 clock and today it is the 06.11.2019 at 16:05 clock.

Here we would like to know how many days, hours and minutes you are old. If we proceed the same way as before in calculating only days and try to get a result in days, minutes and hours, we will fail. Because the formatting dd : hh: mm unfortunately fails in Excel as soon as the result goes beyond 31 days.

The solution for this we do with the function = rounding off (

Enter the following function in the cell in which the result should be:

See picture (click to enlarge)

You can already see that you get a satisfying result with a few small tricks. In the end, of course, you could extend the function by a few seconds, and also other texts as “Min.” or “hrs.” use. But in principle it is feasible in this way.