Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Pay based on time of day hrs worked
Hi, Im setting up a spreadsheet for payroll which so far has start time, end time, total hrs worked and time worked minus break time. I need to set up a function to look at the working times and if between 6am and 6pm calculate number of hrs worked at day rate, then if between 6pm - 6am calculate number of hrs worked at night rate. any ideas? thanks -- scarlett1 ------------------------------------------------------------------------ scarlett1's Profile: http://www.excelforum.com/member.php...o&userid=17495 View this thread: http://www.excelforum.com/showthread...hreadid=384375 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a rate for elapsed time? | Excel Discussion (Misc queries) | |||
I need help with a formula calculating time | Excel Discussion (Misc queries) | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Calculating time difference | Excel Discussion (Misc queries) | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |