Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time sheet calculations
I've got a timesheet built, but it does something slightly unique that
I haven't been able to find an example of or that someone has already asked this question, so here it goes. First, my worksheet has. Column A Date Column B Start time Column C End time Column D Code (R-regular time, C- comp time, V-vacation, etc) Column E Hours (C2-B2)*24 Column F Comp Time Earned =IF(E28,SUM(E2-8),0) What I need to do is to have the total of Comp time earned be deducted if the Code in Column D is "C". I've tried with =IF(D2="C",SUM(F33-E2),0) and it seems to work okay looking at a single cell, but I need to have it look at the whole column and add in a cell for comp time used. Does what I have so far seem like the best way to do it? What should I use to look at the entire column? Better question, does all of this make sense? Thanks in advance. Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time sheet calculations | Excel Worksheet Functions | |||
Excel Used as a Time Sheet | Excel Discussion (Misc queries) | |||
More than calculations in time | Excel Discussion (Misc queries) | |||
Excel formula for a time sheet | Excel Worksheet Functions | |||
Time Sheet calculations | Excel Worksheet Functions |