Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring Late night Hours
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring Late night Hours
It depends on how complicated your rules are.
You have to give more information. First of all, what exactly is considered "late night"? Does the premium rate pertain to *only* the time spent within those exact hours? If 15 minutes is within that time frame, is only that 15 minutes premium? What about 10 minutes? ... 5 minutes? If only 15 minutes falls outside the "late night" period, does that revert back to "regular" rate? Would a total daily wage calculation be required, as opposed to simply separating the different categories of daily work hours into separate columns? Does (will) overtime or lunch breaks come into the picture at all? Care to post what you're presently using? -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "WIgirl" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Figuring Late night Hours
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Figuring out hours worked | Excel Discussion (Misc queries) | |||
calculating time for late hours | Excel Worksheet Functions | |||
Figuring Late Payment on Mortgage | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions | |||
Figuring hours | Excel Worksheet Functions |