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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Question #2
But that doesn't work? I can format it to that time to get the visual affect I want, yes. But, if I enter 117 into an excel cell and use that time format it will visually appear as 01:17:00. However, excel still recognizes this as clock time. (ie 1:17pm) So because it is clock time I cannot...- cstclair9
- Post #3
- Forum: Microsoft: Office
-
-
Excel Question #2
I manage a call center, and the majority of statistics that I track are times..... ie. the average talk time for RepA = 1:17 (1minute 17seconds) Is there any way to quickly format a cell to input stopwatch time, opposed to clock time? Basically all pre-loaded formatting I can find will...- cstclair9
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Excel Formula Question
When adding a division formula, is there a way to program the formula to "skip" a cell within the range identified if there has been no value entered? example: simple %calculation =SUM(B5;N5)/SUM(B6;N6) I am developing a spreadsheet for future use/data entry and am trying to eliminate seeing...- cstclair9
- Thread
- Replies: 2
- Forum: Microsoft: Office
