Thread
:
Make a cell not equal less than a certain number
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
T. Valko
external usenet poster
Posts: 15,768
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?
Reply With Quote
T. Valko
View Public Profile
Find all posts by T. Valko