Percentages on time calculations - microsoft.public.access.reports

Access 2007 - I have a report that calculates downtime based on a combination of Date&Time Up minus Date&Time Down: =(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & [TimeUp]))\60 & ":" & Format((DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & [TimeUp])) Mod 60,"00") (Thankyou to the gurus on this discussion board who haved helped other people with this!) The report is currently grouped according to Downtime Code and calculates totals for each group. I have the following in the footer of each group: =Sum(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & [TimeUp]))\60 & ":" & Format(Sum(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & [TimeUp])) Mod 60,"00") which is working nicely. I now want to calculate the percentage of downtime for each group against the total downtime for the period selected (via a parameter form). I have tried various options but have managed to get exactly nowhere with them. Am I asking too much to calculate percentages on time values? Any help would be greatly appreciated. Thank you in advance! -- cheers pamb

Actually - having had a think about this, it would be way easier if there was a way to convert the calculated time (ie: 4:45hrs) to a decimal value (ie: 4.75hrs) and use that in all my other reports and things I would like to create..... Please help! -- cheers pamb "PamB" wrote: > Access 2007 - I have a report that calculates downtime based on a combination > of Date&Time Up minus Date&Time Down: > > =(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & [TimeUp]))\60 > & ":" & Format((DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & > [TimeUp])) Mod 60,"00") > > (Thankyou to the gurus on this discussion board who haved helped other > people with this!) > > The report is currently grouped according to Downtime Code and calculates > totals for each group. I have the following in the footer of each group: > > =Sum(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & > [TimeUp]))\60 & ":" & Format(Sum(DateDiff("n",[DateDown] & " " & > [TimeDown],[DateUp] & " " & [TimeUp])) Mod 60,"00") > > which is working nicely. > > I now want to calculate the percentage of downtime for each group against > the total downtime for the period selected (via a parameter form). > > I have tried various options but have managed to get exactly nowhere with > them. > > Am I asking too much to calculate percentages on time values? Any help would > be greatly appreciated. Thank you in advance! > > -- > cheers > pamb

Then get rid of all of the formatting =DateDiff("n",[DateDown]+[TimeDown],[DateUp]+[TimeUp])\60 -- Duane Hookom MS Access MVP "PamB" <PamB@discussions.microsoft.com> wrote in message news:B835EB13-E448-4C6E-A9CD-4CB6FFCEA098@microsoft.com... > Actually - having had a think about this, it would be way easier if there > was > a way to convert the calculated time (ie: 4:45hrs) to a decimal value (ie: > 4.75hrs) and use that in all my other reports and things I would like to > create..... > > Please help! > -- > cheers > pamb > > > "PamB" wrote: > >> Access 2007 - I have a report that calculates downtime based on a >> combination >> of Date&Time Up minus Date&Time Down: >> >> =(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & >> [TimeUp]))\60 >> & ":" & Format((DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " >> & >> [TimeUp])) Mod 60,"00") >> >> (Thankyou to the gurus on this discussion board who haved helped other >> people with this!) >> >> The report is currently grouped according to Downtime Code and calculates >> totals for each group. I have the following in the footer of each group: >> >> =Sum(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & >> [TimeUp]))\60 & ":" & Format(Sum(DateDiff("n",[DateDown] & " " & >> [TimeDown],[DateUp] & " " & [TimeUp])) Mod 60,"00") >> >> which is working nicely. >> >> I now want to calculate the percentage of downtime for each group against >> the total downtime for the period selected (via a parameter form). >> >> I have tried various options but have managed to get exactly nowhere with >> them. >> >> Am I asking too much to calculate percentages on time values? Any help >> would >> be greatly appreciated. Thank you in advance! >> >> -- >> cheers >> pamb

Thank you so much Duane. I had taken out the formatting from the reports but hadn't taken it out of the base queries. Just a small thing for anybody else who reads this.... you need to use / not \ to get the decimal places correct. This has been most helpful! I cannot thank you enough. -- cheers pamb "Duane Hookom" wrote: > Then get rid of all of the formatting > =DateDiff("n",[DateDown]+[TimeDown],[DateUp]+[TimeUp])\60 > > -- > Duane Hookom > MS Access MVP > > > "PamB" <PamB@discussions.microsoft.com> wrote in message > news:B835EB13-E448-4C6E-A9CD-4CB6FFCEA098@microsoft.com... > > Actually - having had a think about this, it would be way easier if there > > was > > a way to convert the calculated time (ie: 4:45hrs) to a decimal value (ie: > > 4.75hrs) and use that in all my other reports and things I would like to > > create..... > > > > Please help! > > -- > > cheers > > pamb > > > > > > "PamB" wrote: > > > >> Access 2007 - I have a report that calculates downtime based on a > >> combination > >> of Date&Time Up minus Date&Time Down: > >> > >> =(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & > >> [TimeUp]))\60 > >> & ":" & Format((DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " > >> & > >> [TimeUp])) Mod 60,"00") > >> > >> (Thankyou to the gurus on this discussion board who haved helped other > >> people with this!) > >> > >> The report is currently grouped according to Downtime Code and calculates > >> totals for each group. I have the following in the footer of each group: > >> > >> =Sum(DateDiff("n",[DateDown] & " " & [TimeDown],[DateUp] & " " & > >> [TimeUp]))\60 & ":" & Format(Sum(DateDiff("n",[DateDown] & " " & > >> [TimeDown],[DateUp] & " " & [TimeUp])) Mod 60,"00") > >> > >> which is working nicely. > >> > >> I now want to calculate the percentage of downtime for each group against > >> the total downtime for the period selected (via a parameter form). > >> > >> I have tried various options but have managed to get exactly nowhere with > >> them. > >> > >> Am I asking too much to calculate percentages on time values? Any help > >> would > >> be greatly appreciated. Thank you in advance! > >> > >> -- > >> cheers > >> pamb >

Similiar Articles:

Grouping and percentage calculations - microsoft.public.excel ...
How do I calculate the percentage of email i receive over time ..... Post Question Groups ... Calculate Percent Increase: Use Online Calculator To Find ...

Calculating percentage from eneterd values within a table/form ...
How do I calculate the percentage of email i receive over time ... How to Calculate ... store the results of a form calculation in a table field ... Percentage Calcs ...

How do I calculate the percentage of email i receive over time ...
... Percent Increase: Use Online Calculator To Find ... How to find percentage Increase or Percentage Decrease? ... Money Example: Money's real worth is lost over time and ...

How do I calculate percentages in a report? - microsoft.public ...
How do I calculate the percentage of email i receive over time ... How do I calculate the ... The guidance below will help you work through percentage calculation ...

Calculating percent of a field in two different records ...
I can create a subreport that has these percentages by client by month ... if you need the calculated value, use a query and do the calculation there, in real time. ...

Access 2003:how to calculate percentages in a report - microsoft ...
Calculation for an Access Report - microsoft.public.access ... Calculation for an ... How do I calculate the percentage of email i receive over time ... Percentage Change by ...

Calculating percentage of Total? - microsoft.public.access.queries ...
How do I calculate the percentage of email i receive over time ... Assuming the total ... Marshu.com Calculate Percent of Total - find percentage of total ... Online Calculator ...

how do i calculate percentage of change between two or more field ...
How do I calculate the percentage of email i receive over time ... how do i ... reference main report field in subreport calculation ... how do i calculate percentage of ...

Calculating Percentage in Query. - microsoft.public.access.queries ...
My issue is to calculate the percentage for each company ... public.access ... how to calculate total time in ... Access can be used for a wide variety of calculations.

Form Calculations - microsoft.public.access
Calculating percentage from eneterd values within a table/form ... Form ... If you've used Form Calculator and it has saved you time or money and you'd like ...

Percent Calculator - Online Calculators and Solvers
Percent Calculator ... calculators below will help you to easily calculate the most common percentages.

How to calculate percentages - Math Worksheets, Tables, Charts and ...
The guidance below will help you work through percentage calculation problems ... rained 14 days out of every 100," we say "it rained 14% of the time."

Job Track Time Units Percentage Calculator
Job Track Time Units Percentage Calculator, Palm Springs, Cathedral City, Palm Desert, La Quinta, Desert Hot Springs, Indio, Thermal, Thousand Palms, Rancho Mirage ...

How to Calculate Percentages & Formulas With a Calculator | eHow.com
Your calculator can perform many formulas as well as percentages. When you use a calculator it helps you save time by helping you find the answer to a variety of ...

Percentage Calculations - How To Information | eHow.com
Your calculator can perform many formulas as well as percentages. When you use a calculator it helps you save time by helping you find the answer to a variety of ...

7/18/2012 4:47:57 PM