Calculating Time #5
Time is a wonderful thing......only I have spent ages trying to sor
this problem out with no success, so would be really grateful for som
help from the experts please ...
I have a sheet which is designed as a "work timesheet",
Column D is a start time Eg 09:00
Column E is the finish time EG 16:45
Column G is is a formula to calculate the number of hours worked
=(E1-D1)*24 " which from the above example gives a return of 7.7
The problem I am having is working out a formula to round the tota
minutes worked up to the next half hour eg 7.51 or above rounded up t
Has anyone done a conversion from Achieve Payroll to GP? We have a client
that is looking for a reference.
...Tax-Exempt dividends in a Fidelity Account
I use MSMoney 6.0 and have recently made an investment change that includes
a tax-exempt MM fund.
I am trying to figure out how to make these dividends show up as tax exempt
in the tax section of Money. I have the tax exempt box checked in the
details section of the investment. Right now the dividends show up as
Does anyone have a solution? I was up on a chat session with Microsoft
yesterday and the tech finally just ended my session and went on to her next
Thanks and Merry Christmas to all.
In microsoft.public.money, Levi wrote:
>I use MSMoney 6.0 ...Payroll checklist 2008 payroll close
I have a question on the procedures for 2008 payroll close
1. We already created our year end wage file, step 7, step 8 we did our back
up, step 9 is in process, on steps 10 and 12 if I do this does this affect
the year end wage file already created?? We did not print w2s yet, when i
clear in active employees in step 12 does it just affect process going
forward and not the wage file I already created, I am new at this and this
ism our first gp 10 payroll close.
...a if calculation help
Hi all i have a if calculation which i need to expand but I can't figure it
=IF(AND(D21>=1,D21<=7),"week",IF(AND(D21>=8,D21<=15),"2 wks","3 wks"))
I need to expand it if you can help would be much appriciated
8 - 15 2 wks
16 - 23 3 wks
24 - 31 1 month
32 - 89 2-3 months
90 - 179 6 months
180 + season
I hope you understand that for the numbers i need the result showing in the
i.e. 1- 7 number showing in cell will answer as week
Thankyou for your assistance in advance
360 + season
Create a 2 colu...Using a sql script to retrieve Tax amount detail record from RM
I have a script below to pull the tax detail amount from table RM10601 and
RM00401 and I use query in Excel 2007 to retrieve it to my Excel. However;
if a sales document has two tax transaction, HST and GST, it will be listed
in 2 lines, such as
CUSTNMBR DOCNUMBR DOCDATE ORTOTSLS TAXDTLID ORTAXAMT
KEL8768 1234567 8/1/2009 0:00 100 HST
KEL8768 1234567 8/1/2009 0:00 100 GST
1. How possible to combine two lines of result into a single line with
expected result below.
expected resul...Need formula to calculate bi-monthly pay dates
I need to create a list or table that returns all pay dates for the 15th and
last day of the month for an entire year. The date must adjust forward when
the normal pay date falls on a weekend or holiday, e.g. the 15th is Sunday so
pay day is the 12th. My attempts have resulted in excessive formulas and no
Do you need to account for holidays? This formula works but I don't account
for holidays although it'd be easy enough to do so. I'm thinking some "date
wizard" (a person that is good at date formulas, that's not me!) can
probably ...VBA Make calculation on range
Is there a way i can make calculations on a range of cells without using
using a for each.. next loop. I want to add 10 to the values in a range. You
can do sheet1.range("A:A") = 10 but you can't do = sheet1.range("A:A") + 10.
Talk to you later
No loop is needed:
Set r1 = Range("B1")
Set r2 = Range("A1:A100")
r1.Value = 10
Gary''s Student - gsnu2007L
> Is there a way i can make calculations on a range of...Allocating Tips in Payroll
In one of the forums, someone asked me several questions regarding tip
allocation using GP Payroll. I posted an article to my blog that goes
through the entire calculation, but now I cannot find the thread where the
question was posed.
So, if you are still out there. . . the article was posted to :
I have Microsoft Money 2004 and cannot figure out how to
enter a payroll expense. I need to have gross pay- taxes
and net pay showing as the actual amount of check.
Please help- email email@example.com
Have you tried the special category Paycheck? Look in the sample file or
read in help about Paycheck.
<firstname.lastname@example.org> wrote in message
> I have Microsoft Money 2004 and cannot figure out how to
> enter a payroll expense. I need to have gross pay- taxes
> and net pay showing as the actual amoun...Calculating age #2
How can I calculate a persons age from a birthdate in excel?
This is a quick way but not the best:
If you put the birthdate in A1:
You will need to format the cell with General formatting.
>How can I calculate a persons age from a birthdate in
=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW
(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"
From Chip Pearson's site:
In the Payables Setup Options window, I use an ALL DETAILS tax schedule for
the Tax Schedule IDs as I use a range of tax details. However, this is a bit
of a problem as tax details are often added and not assigned to this tax
schedule. Is there a way to have all details allowed without creating an ALL
DETAILS tax schedule?
thats the only way I am aware of
Richard L. Whaley
Author / Consultant / MVP
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
> ...calculation and save
If I have a table with parmeters and formulas when I want
to save the worksheet it makes automatically ONE more
calculation and then saves. I set it up in the in
tools/option/calculation "automatic" and "automatic except
tables" but the same result happens, when is set it
on "manual" does not save automatically the last result
...Payroll corrections after Payroll Year is closed
I have a client who closed their payroll year and issued W2s. Now,
they've realized that because the last payroll of 2008 was printed on
12/31 but not distributed until January 2nd, it needs to fall into
2009 for wage reporting purposes.
My first thought to correct this was to void the checks from the last
payroll and re-issue them but I've discovered GP won't let you do this
once the payroll year has been closed.
Has anyone ever run into this scenario and if so, how was it
MCP-GP, MCT, MVP
East Coast Dynamics
blog: www....tax-line manager: 401k transfers on paycheck "before tax" tab
Hi. I'm using Money Plus. When I view the tax-line manager for 2007
transactions I have $0.00 for "Form 1040 > Your IRA contributions".
I currently have the portion of my paycheck that goes to my investment
account as a transfer on the "before tax" tab of the paycheck transaction
entry form. I believe that since this is a transfer I cannot add this
category to the tax-line manager. Is the tax-line manager working as I need
it to? I would have thought that I want the "Your IRA contributions" portion
to reflect the amount that has gone from my paychec...Calculate due date 1 or 2 years ahead to the first of the followi.
Issue date is June 12,2004. Certificate is valid ( 24 months ) to July 01,
2006. How do I create this is XL?
> Issue date is June 12,2004. Certificate is valid ( 24 months ) to
> July 01, 2006. How do I create this is XL?
I modified your's ... does this make sence..seem's to work
"Frank Kabel" wrote:
> Frank Kabel
> Frankfurt, Germany
I have heard two conflicting stories:
1) Excel calculates worksheets from left to right in the
2) Excel calculates worksheets in alphabetical order
(based on the worksheet name).
Does anyone know which is correct?
Thanks in advance for your assistance.
Excel 5 and Excel 95 calculate worksheets in the order they are defined.
Excel 97 and 2000 repetitively calculate worksheets in alpahabetic name
sequence until all dependencies are resolved.
Excel2002 and 2003 still calculate worksheets in alphabetic name sequence
but use a global depency table rather than sheet ...Round a Calculations
For labor, we add $50 to our cost and then round to the next highest
$25 increment. So if
the cost was $124, we add $50 using an Iif Statement (iif"laborcost>0,
laborcost+50,0), we would want to round it to the next highest $25
increment so instead of being $174 it would be $175. How can I do
this in a formula or event procedure?
On parts, we like to round to the next highest .99 so if the part was
$7.23, we would want to round that to $7.99.
Can that be done very easily?
>For labor, we add $50 to our cost and then round to the next highest
>$...How to reference main report field in subreport calculation
My main report will populate a field X, but int he sub report, I need to
reference that X value in order to do a calculation. How do I do this and
>My main report will populate a field X, but int he sub report, I need to
>reference that X value in order to do a calculation. How do I do this and
Try using Parent.[field x] in VBA code or in a text box
MVP [MS Access]
My client's payroll hung up when doing a build, she isn't sure why as she had
run one earlier in the day and it was fine. We deleted all the files listed
in the knowledgebase article, and did check links. She can now build the
batch but when she tries to calculate it she gets and error "UPR Temp Post 1
failed, path does not exist", then an "incorrect record length error". I
can't find anything on either of these other than deleting the activity files
and work files of the company database and system.
Any other ideas? There were none of the temp files ...Estimated Taxes not quite right with Business Income
I am new to using Schedule C and I have plugged in my gross receipts and =
expenses and I have it so that the Software Report correctly shows the =
numbers; however I see that in Money Plus Deluxe, the numbers don't show =
up correctly. Is this because I need the Premium or Home and Business =
Version. It is really no big deal as I can override the numbers. I am =
new to doing business receipts and expenses so I hadn't bought the small =
business version and will probably just hold off until the next upgrade.
...No Distribution for Payroll Check
My company just started using GP 10 after the first of the year. I
have one employee whose check distribution did not balance. Their
deductions and unemployment taxes were deducted from their check but
it was not distributioned to a G/L account. What should I be looking
at to correct this so that it doesn't happen again?
...Removing tax on an old invoice
I invoiced a customer and they mailed me a check minus sales tax along
with a note reminding me they are tax exempt. (We just switched to RMS
and I failed to flag them as exempt when I created them in the system).
How should I handle this? Our old system was more basic and allowed me
to open past invoices and edit them to fix things like this. I'm
having a hard time transitioning into this new way where things are
more set in stone. I wish I could edit their invoice and remove the
tax but I have a hunch I can't. Do I need to void the invoice and make
a new one? Or adjust their a...Canadian Payroll vs US Payroll
Can someone tell me the differences in the tables and fields which are
populated and updated in Canadian Payroll vs US Payroll?
The quick answer: Everything!!!
In Canadian Payroll, there are over 200 tables all with their physical
names prefixed by CPY. I wouldn't even hazard a guess at the number of
fields in there let alone guess at the number of tables and fields in
the US Payroll which is totally separate.
They are all listed under Tools > Resource Descriptions > Tables if you
have those products installed.
Good luck on your count and in deciding what is populated and/or
How to change the Soc.Sec Number format in Payroll module.
>How to change the Soc.Sec Number format in Payroll module.
>How to change the Soc.Sec Number format in Payroll module.
What do you want to change it to?
> How to change the Soc.Sec Number format in Payroll module.