Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time formulas
Hello, I would like assistance with a "simple" time formula. a b 1 9:15:00 9:20:05 The formula I tried to use was "=a1-b1" but no luck. Suggestions would be appreciated. Thanks & Cheers |
#2
|
|||
|
|||
Negative times display as ######## in the 1900 date system. If you want
see negative times, you can change to the 1904 date system (Tools/Options/Calculation). For more, see http://cpearson.com/excel/datetime.htm#AddingTimes In article , "edver" wrote: Hello, I would like assistance with a "simple" time formula. a b 1 9:15:00 9:20:05 The formula I tried to use was "=a1-b1" but no luck. Suggestions would be appreciated. Thanks & Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |