software

I'm creating a timesheet workbook for my employer. quot;Night
differentialquot; is paid from 1800 to 0600. quot;Regular payquot; applies to the
rest of the day. We have to show time spent on various job tasks across
a day. Beneath each tsak are cells labeled quot;startquot; and quot;stop.quot; Each
task lists 3 to 4 quot;startquot;/quot;stopquot; periods. The only way I've worked
out to calculate quot;night differentialquot; is to quot;startquot; or quot;stopquot; exactly
at 1800 or quot;startquot; or quot;stopquot; at 0600. Is there a way to make excel
seperate night differential from regular pay if a quot;startquot; time listed,
for example, 1700 and had a quot;stopquot; time of 1900?
bafabafa wrote:
gt; I'm creating a timesheet workbook for my employer. quot;Night
gt; differentialquot; is paid from 1800 to 0600. quot;Regular payquot; applies to the
gt; rest of the day. We have to show time spent on various job tasks
gt; across a day. Beneath each tsak are cells labeled quot;startquot; and
gt; quot;stop.quot; Each task lists 3 to 4 quot;startquot;/quot;stopquot; periods. The only
gt; way I've worked out to calculate quot;night differentialquot; is to quot;startquot;
gt; or quot;stopquot; exactly at 1800 or quot;startquot; or quot;stopquot; at 0600. Is there a
gt; way to make excel seperate night differential from regular pay if a
gt; quot;startquot; time listed, for example, 1700 and had a quot;stopquot; time of 1900?
gt; bafa

See my earlier post at tinyurl.com/h6zhc