Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Formulae-using time formats
Just started to use time formats in Excel 97. Need to enter a formula that says if a cell is greater than 7.5 hours (7:30) then pick up the contents of that cell, otherwise put in 7:30 (in time format) Have no problems with the normal formula =if(c7>7.5,c7,"") but this won't work...- Babsie
- Thread
- Replies: 2
- Forum: Microsoft: Office
