Percentages on time calculations

  • Thread starter Thread starter PamB
  • Start date Start date
P

PamB

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!
 
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!
 
Then get rid of all of the formatting
=DateDiff("n",[DateDown]+[TimeDown],[DateUp]+[TimeUp])\60

--
Duane Hookom
MS Access MVP


PamB said:
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 said:
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!
Click to expand...
Click to expand...
 
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 said:
Then get rid of all of the formatting
=DateDiff("n",[DateDown]+[TimeDown],[DateUp]+[TimeUp])\60

--
Duane Hookom
MS Access MVP


PamB said:
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 said:
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!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top