Subtract hours from time

This tutorial shows how to subtract hours from time using an Excel formula, with the MOD function

Excel

Subtract hours from time using MOD function

EXCEL FORMULA 1. Subtract hours from time

EXCEL

Hard coded formula

Cell reference formula

=MOD(B5-(1/24),1)

=MOD(B5-(C5/24),1)

GENERIC FORMULA

=MOD(time-(hours/24),1)

ARGUMENTS
time: The time to subtract hours from.
hours: Number of hours to subtract from the time.

GENERIC FORMULA

=MOD(time-(hours/24),1)

ARGUMENTS
time: The time to subtract hours from.
hours: Number of hours to subtract from the time.

EXPLANATION

This formula uses the MOD function to subtract a number of hours from a specific time.

Click on either the Hard Coded or Cell Reference button to view the formula that has a number of hours that are to be subtracted from a specific time directly entered into the formula or referenced to a specific cell.