If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

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.

Step 1: In this specific example, I’ll be calculating the difference between the profit and revenue. Select the cell you want the percentage to appear within. Now type in = (B2-C2)/B2.