Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there something like an "If, then" formula?
I am trying to set up a time card that I downloaded from the templates page
on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e. 56.4 hours for the week. What I would like it to do is when the total number of hours reaches 40, then anything over that goes into another cell for the number of over-time hours. Is there a formula that anyone knows that I can use for this, or a function? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there something like an "If, then" formula?
use a formula in the other cell of
=MAX(total_time-40,0) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "~working mom~" <~working wrote in message ... I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e. 56.4 hours for the week. What I would like it to do is when the total number of hours reaches 40, then anything over that goes into another cell for the number of over-time hours. Is there a formula that anyone knows that I can use for this, or a function? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there something like an "If, then" formula?
The simplest way would be to add 2 columns, normal time and overtime. If
straight time is in F2, then in say G2 enter =IF(F2<=40,F2,IF(F240,40,"")) and in H2 enter =IF(F2="","",IF(F2<=40,0,F2-40)) "~working mom~" wrote: I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e. 56.4 hours for the week. What I would like it to do is when the total number of hours reaches 40, then anything over that goes into another cell for the number of over-time hours. Is there a formula that anyone knows that I can use for this, or a function? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there something like an "If, then" formula?
Thank you, that works for figuring the weekly overtime out. Do you know how
to make the "total hours" cell stop at 40? So that I have Regular hours 40 and then in the other cell it show the number of OT hours? Right now it shows: regular hours 42.5 OT hours 2.5. "Bob Phillips" wrote: use a formula in the other cell of =MAX(total_time-40,0) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "~working mom~" <~working wrote in message ... I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e. 56.4 hours for the week. What I would like it to do is when the total number of hours reaches 40, then anything over that goes into another cell for the number of over-time hours. Is there a formula that anyone knows that I can use for this, or a function? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is there something like an "If, then" formula?
Yeah,
=MAX(total_hours,40) but don't use the result of this in the overtime calculation <vbg -- HTH Bob Phillips (remove nothere from email address if mailing direct) "~working mom~" wrote in message ... Thank you, that works for figuring the weekly overtime out. Do you know how to make the "total hours" cell stop at 40? So that I have Regular hours 40 and then in the other cell it show the number of OT hours? Right now it shows: regular hours 42.5 OT hours 2.5. "Bob Phillips" wrote: use a formula in the other cell of =MAX(total_time-40,0) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "~working mom~" <~working wrote in message ... I am trying to set up a time card that I downloaded from the templates page on MS. I like the format of the one that I have, but this is what I want it to do: Currently it is set up to calculate time for the week as streight time, i.e. 56.4 hours for the week. What I would like it to do is when the total number of hours reaches 40, then anything over that goes into another cell for the number of over-time hours. Is there a formula that anyone knows that I can use for this, or a function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |