Add or subtract two time values. Supports days, hours, minutes, and seconds. Blank fields are treated as 0.
Time is measured using many units. While it can be added or subtracted like numbers, units vary in length. Here's a guide to help you understand:
Unit | Definition |
---|---|
Millennium | 1,000 years |
Century | 100 years |
Decade | 10 years |
Year | 365.242 days (avg) |
Month | 28–31 days |
Week | 7 days |
Day | 24 hours / 1,440 min / 86,400 sec |
Hour | 60 minutes or 3,600 seconds |
Minute | 60 seconds |
Second | Base time unit |
Millisecond | 1/1,000 of a second |