Time sheet for day/time work hours

Microsoft Office 2007 home and student
September 22, 2009 at 15:50:53
Specs: Windows XP Pro
Hi,

In a time sheet I have created, there is
start/end work time which works O.K.
My problem is, that between 0:00 and 6:00
(night shift) there is different pay rate, so I have
to calculate those night hours (using IF
expression, I believe....) and represent day
and night working hours separately.

Question: how to make formula checking the
"End Work" before midnight and split working
hours in 2 different cells?

Thank you


See More: Time sheet for day/time work hours

Report •


#1
September 22, 2009 at 16:24:29
Post this in the Office Software forum on the right of this page

Home Page http://ewen.uuuq.com/


Report •
Related Solutions


Ask Question