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 |