Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 181
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CONVERT TOTAL HOURS TO REGULAR AND OVERTIME Mark Excel Discussion (Misc queries) 3 October 10th 06 07:00 PM
Time Sheets - regular vs overtime Susan Excel Worksheet Functions 2 August 29th 06 08:52 PM
convert military time to regular hours Kathy Excel Worksheet Functions 1 April 25th 06 01:20 PM
Work out overtime hours for individuals Fudge New Users to Excel 13 April 10th 06 04:10 PM
Overtime Hours Zack Excel Worksheet Functions 5 November 23rd 05 04:28 PM


All times are GMT +1. The time now is 04:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"