Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
I am making a time sheet that has the punch in and out times. An employees
work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hours work and another cell with their hourly pay. What is the formula to make the total days hour cell not less than 5 hours? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
Try something like this...
A1 = start time B1 = end time =IF(COUNT(A1:B1)=2,MAX(MOD(B1-A1,1)*24,5),"") -- Biff Microsoft Excel MVP "Karl Davidson" <Karl wrote in message ... I am making a time sheet that has the punch in and out times. An employee's work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hour's work and another cell with their hourly pay. What is the formula to make the total day's hour cell not less than 5 hours? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
Thank you for your help. Another question is how does one computer hours and
minutes past midnight? I currently am using the following formulas in three different cells which deals with time only. =(StartTime-INT(StartTime))*24 =(EndTime-INT(EndTime))*24 =TEXT(EndTime-StartTime12,"0.00") "T. Valko" wrote: Try something like this... A1 = start time B1 = end time =IF(COUNT(A1:B1)=2,MAX(MOD(B1-A1,1)*24,5),"") -- Biff Microsoft Excel MVP "Karl Davidson" <Karl wrote in message ... I am making a time sheet that has the punch in and out times. An employee's work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hour's work and another cell with their hourly pay. What is the formula to make the total day's hour cell not less than 5 hours? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
Another question is how does one computer hours
and minutes past midnight? That's already built into my formula. This is the portion that does that: MOD(B1-A1,1) And then multiplying by 24 converts it for display as a decimal value: MOD(B1-A1,1)*24 A1 = 11:00 PM B1 = 7:00 AM =MOD(B1-A1,1)*24 = 8 -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... Thank you for your help. Another question is how does one computer hours and minutes past midnight? I currently am using the following formulas in three different cells which deals with time only. =(StartTime-INT(StartTime))*24 =(EndTime-INT(EndTime))*24 =TEXT(EndTime-StartTime12,"0.00") "T. Valko" wrote: Try something like this... A1 = start time B1 = end time =IF(COUNT(A1:B1)=2,MAX(MOD(B1-A1,1)*24,5),"") -- Biff Microsoft Excel MVP "Karl Davidson" <Karl wrote in message ... I am making a time sheet that has the punch in and out times. An employee's work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hour's work and another cell with their hourly pay. What is the formula to make the total day's hour cell not less than 5 hours? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
Once again, thank you. Dont quite understand why the 1 is in the formula.
Nevertheless, it works. With this timesheet, I have to compute a night pay rate for those who work between 22:00 to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? "T. Valko" wrote: Another question is how does one computer hours and minutes past midnight? That's already built into my formula. This is the portion that does that: MOD(B1-A1,1) And then multiplying by 24 converts it for display as a decimal value: MOD(B1-A1,1)*24 A1 = 11:00 PM B1 = 7:00 AM =MOD(B1-A1,1)*24 = 8 -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... Thank you for your help. Another question is how does one computer hours and minutes past midnight? I currently am using the following formulas in three different cells which deals with time only. =(StartTime-INT(StartTime))*24 =(EndTime-INT(EndTime))*24 =TEXT(EndTime-StartTime12,"0.00") "T. Valko" wrote: Try something like this... A1 = start time B1 = end time =IF(COUNT(A1:B1)=2,MAX(MOD(B1-A1,1)*24,5),"") -- Biff Microsoft Excel MVP "Karl Davidson" <Karl wrote in message ... I am making a time sheet that has the punch in and out times. An employee's work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hour's work and another cell with their hourly pay. What is the formula to make the total day's hour cell not less than 5 hours? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Make a cell not equal less than a certain number
Replied to your other post.
-- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... Once again, thank you. Don't quite understand why the 1 is in the formula. Nevertheless, it works. With this timesheet, I have to compute a night pay rate for those who work between 22:00 to 06:00 the following day. Can this information be taken from the Start Time and Ending Time? "T. Valko" wrote: Another question is how does one computer hours and minutes past midnight? That's already built into my formula. This is the portion that does that: MOD(B1-A1,1) And then multiplying by 24 converts it for display as a decimal value: MOD(B1-A1,1)*24 A1 = 11:00 PM B1 = 7:00 AM =MOD(B1-A1,1)*24 = 8 -- Biff Microsoft Excel MVP "Karl Davidson" wrote in message ... Thank you for your help. Another question is how does one computer hours and minutes past midnight? I currently am using the following formulas in three different cells which deals with time only. =(StartTime-INT(StartTime))*24 =(EndTime-INT(EndTime))*24 =TEXT(EndTime-StartTime12,"0.00") "T. Valko" wrote: Try something like this... A1 = start time B1 = end time =IF(COUNT(A1:B1)=2,MAX(MOD(B1-A1,1)*24,5),"") -- Biff Microsoft Excel MVP "Karl Davidson" <Karl wrote in message ... I am making a time sheet that has the punch in and out times. An employee's work day is a minimum of 5 hours or greater. For an example: an employee works 3 hours, they received 5 hours credit. I have a cell that has the total hour's work and another cell with their hourly pay. What is the formula to make the total day's hour cell not less than 5 hours? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
How to make text in a cell equal a number | Excel Discussion (Misc queries) | |||
make a single cell always equal zero | Excel Worksheet Functions | |||
make cell length always equal 10 | Excel Discussion (Misc queries) | |||
How do I make one cell equal to another | Excel Worksheet Functions |