WIgirl;366917 Wrote:
I have a timesheet that allows employees to enter their start and end
times
in regular time format. The current formulas then add up the amount of
time
actually worked wich is also deleivered in regular time format.

Employees get an extra amount of money for working late night hours, so
I
would like to figure their time separately. For example they worked a
total
of 4:45 at (4h 45m) at the regular wage and then 2:00 (2h 0m) at the
higher
rate time.

In essence Excel will have to look at the start and end times and
determine
if they fall between the "late night hours" then add the two times
separatley.

Any ideas? Is this even possible?

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join *you will have the
opportunity to add attachmnets to your posts* so you can add workbooks
to better illustrate your problems and get help directly with them. Also
if you do join please post in this thread (link found below) so that
people who have been following or helping with this query can continue
to do so. :)


--
Pecoflyer

Cheers -
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=102783