MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### Percentages on time calculations

• Follow

```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
```
 0

```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.....

--
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
```
 0

```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...
> 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.....
>
> --
> 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

```
 0

```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...
> > 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.....
> >
> > --
> > 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
>
```
 0

3 Replies
156 Views

Similiar Articles:

7/18/2012 4:47:57 PM