Subtract seconds from time

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

EXCEL FORMULA 1. Subtract seconds from time

EXCEL

Hard coded formula
Subtract seconds from time
Cell reference formula
Subtract seconds from time
=MOD(B5-(60/86400),1)
=MOD(B5-(C5/86400),1)
GENERIC FORMULA

=MOD(time-(seconds/86400),1)

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

GENERIC FORMULA

=MOD(time-(seconds/86400),1)

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

EXPLANATION

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

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

RELATED TOPICS

Related Topic Description Related Topic and Description
How to add seconds to time
How to add minutes to time
How to subtract minutes from time
How to add hours to time
How to subtract hours from time

RELATED FUNCTIONS

Related Functions Description Related Functions and Description
The Excel MOD function returns the remainder after dividing a number by the divisor