ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   regular and overtime hours (https://www.excelbanter.com/excel-worksheet-functions/139853-regular-overtime-hours.html)

Curtis

regular and overtime hours
 
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.

T. Valko

regular and overtime hours
 
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.





All times are GMT +1. The time now is 09:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com