T
tirdreamer
In short, I'm helping a friend design new payroll sheets for her compan
and my only real hangup is their graveyard shift. the hours from 10pm t
6am need to be calculated or pulled from their regular hours(any outsid
of that range) and put in another cell. I can use the formulas from th
pre-designed time sheets and schedule templates I downloaded to figur
out the basic time formulas to calculate hours worked. (I have the 200
version of excel and pulled the basic templates of the web that ar
available for registered excel users) From the employees entering th
times that they worked, each time in a different cell, I can calculat
hours worked, but from those times, I need to calculate how many o
those hours were graveyard hours and have that value in it's own cell
If anyone out there is good with these time formulas, please give me
clue, cause I can't seem to get anywhere on this snag. Thanks i
advance.
Tirdreamer:
and my only real hangup is their graveyard shift. the hours from 10pm t
6am need to be calculated or pulled from their regular hours(any outsid
of that range) and put in another cell. I can use the formulas from th
pre-designed time sheets and schedule templates I downloaded to figur
out the basic time formulas to calculate hours worked. (I have the 200
version of excel and pulled the basic templates of the web that ar
available for registered excel users) From the employees entering th
times that they worked, each time in a different cell, I can calculat
hours worked, but from those times, I need to calculate how many o
those hours were graveyard hours and have that value in it's own cell
If anyone out there is good with these time formulas, please give me
clue, cause I can't seem to get anywhere on this snag. Thanks i
advance.
Tirdreamer: