software

Looking for the best way to calculate employee attendance based on when they
log in and out for the day. It has to compare to the employees start/end time
for each day of the week. Any suggestions?
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.


Is it as simple as subtracting one time from the other or am I missing
the point?--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
View this thread: www.excelforum.com/showthread...hreadid=539330How do you subtract when the shift rolls over from one day to the next?

--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.quot;mricequot; wrote:

gt;
gt; Is it as simple as subtracting one time from the other or am I missing
gt; the point?
gt;
gt;
gt; --
gt; mrice
gt;
gt; Research Scientist with many years of spreadsheet development experience
gt; ------------------------------------------------------------------------
gt; mrice's Profile: www.excelforum.com/member.php...oamp;userid=10931
gt; View this thread: www.excelforum.com/showthread...hreadid=539330
gt;
gt;

Thanks mrice for your help. I found a site via another thread that seems to
have all my answers. www.cpearson.com/excel/datetime.htm#WorkHours

thansk for the help.
--
Life is an adventure, are you living it?

These are just my opinions, please feel free to correct them if they are
wrong.quot;Hanr3quot; wrote:

gt; Looking for the best way to calculate employee attendance based on when they
gt; log in and out for the day. It has to compare to the employees start/end time
gt; for each day of the week. Any suggestions?
gt; --
gt; Life is an adventure, are you living it?
gt;
gt; These are just my opinions, please feel free to correct them if they are
gt; wrong.