Just remembered something I picked up from Peo a while ago about entering
times:
*Temporarily* use Auto Correct!
Go to <Tools> <AutoCorrect>
And in "Replace With", enter a period (.)
And in "With", enter a colon
)
Then <OK>
Most of the office staff is proficient in working "Ten Key", so the period
(decimal point) is almost second nature to them for easy and fast number
entry.
And of course, after the time cards are done, just go and change things back
to normal by deleting the alteration.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
ColA= day of week - Start on Row9
B = Start Time - All Times entered as 9:00 or 22:00
C = Time Out (lunch)
D = Time In (back from lunch)
E = End Time
F = Ttl Hours Present =((E9-B9+(E9<B9))*24)*AND(B9<>0,E9<>0)
G = Ttl Hours Worked =IF(F9>0,((E9-B9+(E9<B9))-(D9-C9+(D9<C9)))*24,0)
H = Hours Reg (Straight Time) Pay =MIN(8,G9)
I = Hours O.T. (Calif. Rules - over 8 per day)
=IF(G9-8>4,4,IF(G9-8<0,0,G9-8))
J = Hours Dbl. Time (over 12 per day) =MAX(0,G9-12)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
Checked for templates but didn't find one for this:
We are a 24/7 facility in which there are a number of
people that work the overnight shift. They begin during
the evening around 22:00 and work until the following
morning, 8:00. Other than making the next day hours as
32:00 (for 8:00) we have been unable to create a formula
that correctly calculates the time. Can you help?
Thanks
PS There are also meal breaks in between.
