Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Need help on solving a problem, I have A1 to G1 as (Sun thru Sat) for Days
off with pay, A2 to G2 where I put hours; then A3 to G3 is for regular hours; then A4 to G4 is overtime hours, I have the regular hours ( A3 to G3 ) set up perfect to work with overtime hours ( A4 to G4), Question is how do you get overtime hours from A2 to G2 to work in A4 to G4 too if not using A3 to G3? I like roll A4 to G4 over time to beable to calculate from either roll A2 to G2 or A3 to G3. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm pretty sure that we're going to need to see an example with the
explanation. Biff "Curtis" wrote in message ... Need help on solving a problem, I have A1 to G1 as (Sun thru Sat) for Days off with pay, A2 to G2 where I put hours; then A3 to G3 is for regular hours; then A4 to G4 is overtime hours, I have the regular hours ( A3 to G3 ) set up perfect to work with overtime hours ( A4 to G4), Question is how do you get overtime hours from A2 to G2 to work in A4 to G4 too if not using A3 to G3? I like roll A4 to G4 over time to beable to calculate from either roll A2 to G2 or A3 to G3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CONVERT TOTAL HOURS TO REGULAR AND OVERTIME | Excel Discussion (Misc queries) | |||
Time Sheets - regular vs overtime | Excel Worksheet Functions | |||
convert military time to regular hours | Excel Worksheet Functions | |||
Work out overtime hours for individuals | New Users to Excel | |||
Overtime Hours | Excel Worksheet Functions |