Main Profile

At A Glance

Excel Magic Trick #173: Time Over or Under (Negative Time)

See how to show Negative time with the "Use 1904 date system". See how to create a formula that will show the time over or under a hurdle. The IF function uses a logical test to put one of two things into a cell. The OR function allows you to have multiple logical tests and if any one (at least one) comes out to be TRUE, then the OR function delivers a TRUE. To add Custom Format, Ctrl + 1 (to open Format Cells Dialog Box), click on the number tab, click on Custom. To change the settings to "Use 1904 date system": 1) Excel 2003, go to Tools menu, Options, Calculation tab, then check "Use 1904 date system"; 2) Excel 2007: Office Button, Excel Options, then click on the Advanced tab on the left, then scroll down to "When calculating this workbook", then check "Use 1904 date system".
Length: 07:56

Contact

Questions about Excel Magic Trick #173: Time Over or Under (Negative Time)

Want more info about Excel Magic Trick #173: Time Over or Under (Negative Time)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question