About Us

Wanna Learn

Sandy Mann
EXCELLENT! thanks

"Sandy Mann" wrote:

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)

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
incomplete name on y axis	jdhcrbc	Excel Discussion (Misc queries)	0	August 10th 08 11:32 PM
Incomplete scroll bar	bubbaslb	Excel Discussion (Misc queries)	0	November 30th 07 08:55 PM
Sorting is Incomplete	Patlee	Excel Discussion (Misc queries)	13	May 26th 07 07:30 PM
oldest incomplete job	floridasurfn	Excel Worksheet Functions	3	July 11th 06 05:42 PM
Mail Merge incomplete	cneisen	New Users to Excel	2	May 6th 05 11:12 PM

Menu

About Us