Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula incomplete
Hello I have an attendance sheet . this is the formula I am using for sick
days =COUNTIF($I11:$BV11, "S")+(COUNTIF($I11:$BV11, "S1")/2). "S" = sick . the formula calculates sick time for a month . Now, my problem is that sometimes people take "hours sick" so this does not equal to one whole day or 1/2 day. The working day is 7.30 hours. How do I adjust the formula so that is shows the total time out sick for the month . example if the person was sick for 1 day and 4 hours during the month my total should read 1.55 thanks in advance ( I have excel 2002) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula incomplete
If there is going to be various hours of sickness why not just enter the
hours off sick as decimals, including 7.5 for a whole day, and then use: =ROUND(SUM(B2:G2)/7.5,2) -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Wanna Learn" wrote in message ... Hello I have an attendance sheet . this is the formula I am using for sick days =COUNTIF($I11:$BV11, "S")+(COUNTIF($I11:$BV11, "S1")/2). "S" = sick . the formula calculates sick time for a month . Now, my problem is that sometimes people take "hours sick" so this does not equal to one whole day or 1/2 day. The working day is 7.30 hours. How do I adjust the formula so that is shows the total time out sick for the month . example if the person was sick for 1 day and 4 hours during the month my total should read 1.55 thanks in advance ( I have excel 2002) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
incomplete name on y axis | Excel Discussion (Misc queries) | |||
Incomplete scroll bar | Excel Discussion (Misc queries) | |||
Sorting is Incomplete | Excel Discussion (Misc queries) | |||
oldest incomplete job | Excel Worksheet Functions | |||
Mail Merge incomplete | New Users to Excel |