| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Sheets - regular vs overtime
I am having an issue with calculating the time for regular and overtime. I
want the results to be automated and every formula, if statement and min/max statements I have tried are unsuccessful. Here is an example: WEEKLY TOTAL Total hours: 92:20 Regular hours: #NAME? Overtime hours: |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheets - regular vs overtime
For regular hours you can use
=MIN(40/24,A1) For overtime hours you can use =MAX(A1-40/24,0) Be sure to set the format of both like this [h]:mm "Susan" wrote: I am having an issue with calculating the time for regular and overtime. I want the results to be automated and every formula, if statement and min/max statements I have tried are unsuccessful. Here is an example: WEEKLY TOTAL Total hours: 92:20 Regular hours: #NAME? Overtime hours: |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Time Sheets - regular vs overtime
Thank you, you are awesome...it works!!!
"Sloth" wrote: For regular hours you can use =MIN(40/24,A1) For overtime hours you can use =MAX(A1-40/24,0) Be sure to set the format of both like this [h]:mm "Susan" wrote: I am having an issue with calculating the time for regular and overtime. I want the results to be automated and every formula, if statement and min/max statements I have tried are unsuccessful. Here is an example: WEEKLY TOTAL Total hours: 92:20 Regular hours: #NAME? Overtime hours: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i highlight dupplicated in 2 sheets at a time? | Excel Worksheet Functions | |||
| How do I protect multiple sheets at one time? | Excel Worksheet Functions | |||
| Time Sheets | Excel Discussion (Misc queries) | |||
| Time Sheets | Excel Worksheet Functions | |||
| Setting up scheduling and Time sheets for Payroll | Excel Worksheet Functions | |||
Hybrid Mode
