| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
IF Formulas
Can someone please help me figure out this formula as I am a beginner! =IF(M9=0,"",M9-L9) = Active =IF(M10=0,"",H10/P10) = Productivity Time(G) First (H) Last(I) Active(J) Productivity(K) All Activity Activity 1) 1:19:00 7:00:24 AM 12:28:45 PM 22.80% 24.06% 2) 2:19:58 9:06:01 AM 4:56:29 PM 32.67% 29.75% 3) 2:09:37 7:01:10 AM 2:57:51 PM 33.10% 27.19% 4) 1:37:43 1:00:17 PM 5:59:55 PM 20.81% 32.61% I am trying to determine what the active and productivity %'s mean. G, H, and I are all times for agents log in (time all), first activity(H) and last activity (I). Then what does the productivity mean. Please Please help -- royrobinson1 ------------------------------------------------------------------------ royrobinson1's Profile: http://www.excelforum.com/member.php...o&userid=35275 View this thread: http://www.excelforum.com/showthread...hreadid=550516 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Threaded Mode
