Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Timesheet maximum hours problem
I have created a time sheet for biweekly payroll, but I have one
problem. Cell: I12 is the total for one week Cell: D24 is the above total copied Cell:D26 is regular hours worked - and this is where I have the problem. I want this cell to copy the value from D24 or input 44:00 hours, which ever is less, in time format. Can you help Thank you |
#2
|
|||
|
|||
Timesheet maximum hours problem
=Min(D24,time(44,0,0))
and format as time -- HTH RP (remove nothere from the email address if mailing direct) "Good Time" wrote in message ... I have created a time sheet for biweekly payroll, but I have one problem. Cell: I12 is the total for one week Cell: D24 is the above total copied Cell:D26 is regular hours worked - and this is where I have the problem. I want this cell to copy the value from D24 or input 44:00 hours, which ever is less, in time format. Can you help Thank you |
#3
|
|||
|
|||
Timesheet maximum hours problem
Thanks for your response but this formla seems to return
a fixed value of 22:00. Am I doing something wrong? =Min(D24,time(44,0,0)) and format as time |
#4
|
|||
|
|||
Timesheet maximum hours problem
See Peo's response.
-- HTH RP (remove nothere from the email address if mailing direct) "Good Time" wrote in message ... Thanks for your response but this formla seems to return a fixed value of 22:00. Am I doing something wrong? =Min(D24,time(44,0,0)) and format as time |
#5
|
|||
|
|||
Timesheet maximum hours problem
Hi!
Try this: =MIN(D24,44/24) Format the cell as [h]:mm. Biff "Good Time" wrote in message ... I have created a time sheet for biweekly payroll, but I have one problem. Cell: I12 is the total for one week Cell: D24 is the above total copied Cell:D26 is regular hours worked - and this is where I have the problem. I want this cell to copy the value from D24 or input 44:00 hours, which ever is less, in time format. Can you help Thank you |
#6
|
|||
|
|||
Timesheet maximum hours problem
Thanks for your help but this formula always returns the value 44:00.
The problem is if cell D24 is less than 44:00 hours, let say 22:00 than cell D26 should reflect 22:00. If cell D24 is greater than 44:00 than cell D26 should reflect the maximum of 44:00 which your formula does. Can you help? Hi! Try this: =MIN(D24,44/24) Format the cell as [h]:mm. Biff "Good Time" wrote in message .. . I have created a time sheet for biweekly payroll, but I have one problem. Cell: I12 is the total for one week Cell: D24 is the above total copied Cell:D26 is regular hours worked - and this is where I have the problem. I want this cell to copy the value from D24 or input 44:00 hours, which ever is less, in time format. Can you help Thank you |
#7
|
|||
|
|||
Timesheet maximum hours problem
No it's not always returning 44, so the only other option is that the 22:00
is either text or not 22:00 -- Regards, Peo Sjoblom "Good Time" wrote in message ... Thanks for your help but this formula always returns the value 44:00. The problem is if cell D24 is less than 44:00 hours, let say 22:00 than cell D26 should reflect 22:00. If cell D24 is greater than 44:00 than cell D26 should reflect the maximum of 44:00 which your formula does. Can you help? Hi! Try this: =MIN(D24,44/24) Format the cell as [h]:mm. Biff "Good Time" wrote in message .. . I have created a time sheet for biweekly payroll, but I have one problem. Cell: I12 is the total for one week Cell: D24 is the above total copied Cell:D26 is regular hours worked - and this is where I have the problem. I want this cell to copy the value from D24 or input 44:00 hours, which ever is less, in time format. Can you help Thank you |
#8
|
|||
|
|||
Timesheet maximum hours problem
That was the problem, one of my cells had text in it.
Thanks so much for your help. No it's not always returning 44, so the only other option is that the 22:00 is either text or not 22:00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
add hours (calculated by functions) on a timesheet | Excel Worksheet Functions | |||
How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
Timesheet Problem | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |