software

I am looking for a formula that can help me calculate hours worked by addiing
start and end times. I would like it to calculate the time by quarter hours
with 8 minutes being the up or down trigger.

Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours

Any assistance would be appreciated.

Thank you!
M.

If the start and end times are in B2 and C2, respectively, then
=24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
24 turns the time value into the number of hours).
--Bruce

quot;mmockquot; wrote:

gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; start and end times. I would like it to calculate the time by quarter hours
gt; with 8 minutes being the up or down trigger.
gt;
gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt;
gt; Any assistance would be appreciated.
gt;
gt; Thank you!
gt; M.

HI Bruce:

Thanks for the reply. Sorry about the delay now, I was away fora few days.
I tried this formula and something I did nust be wrong couse all I get is
#NAME?
I like the theory, maybe you can give me a better example with the start and
end times Ive provided.
Thanks again,
Mark

quot;bpeltzerquot; wrote:

gt; If the start and end times are in B2 and C2, respectively, then
gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; 24 turns the time value into the number of hours).
gt; --Bruce
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; with 8 minutes being the up or down trigger.
gt; gt;
gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt;
gt; gt; Any assistance would be appreciated.
gt; gt;
gt; gt; Thank you!
gt; gt; M.

MROUND required the Analysis ToolPak Add-in. On the menu bar Tools gt;
add-ins, select Analysis ToolPak and click OK.

quot;mmockquot; wrote:

gt; HI Bruce:
gt;
gt; Thanks for the reply. Sorry about the delay now, I was away fora few days.
gt; I tried this formula and something I did nust be wrong couse all I get is
gt; #NAME?
gt; I like the theory, maybe you can give me a better example with the start and
gt; end times Ive provided.
gt; Thanks again,
gt; Mark
gt;
gt;
gt;
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; If the start and end times are in B2 and C2, respectively, then
gt; gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; gt; 24 turns the time value into the number of hours).
gt; gt; --Bruce
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; gt; with 8 minutes being the up or down trigger.
gt; gt; gt;
gt; gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt; gt;
gt; gt; gt; Any assistance would be appreciated.
gt; gt; gt;
gt; gt; gt; Thank you!
gt; gt; gt; M.

Bruce:

I did the add on, got the foluma to work but it is not calculating properly.
I used a start time on 8:30 and a stop time of 13:38 and it gave me 6 hours.
I changed the stop time to 13:37 and still got 6 hours???

We are getting there!!
M.quot;bpeltzerquot; wrote:

gt; MROUND required the Analysis ToolPak Add-in. On the menu bar Tools gt;
gt; add-ins, select Analysis ToolPak and click OK.
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; HI Bruce:
gt; gt;
gt; gt; Thanks for the reply. Sorry about the delay now, I was away fora few days.
gt; gt; I tried this formula and something I did nust be wrong couse all I get is
gt; gt; #NAME?
gt; gt; I like the theory, maybe you can give me a better example with the start and
gt; gt; end times Ive provided.
gt; gt; Thanks again,
gt; gt; Mark
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;bpeltzerquot; wrote:
gt; gt;
gt; gt; gt; If the start and end times are in B2 and C2, respectively, then
gt; gt; gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; gt; gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; gt; gt; 24 turns the time value into the number of hours).
gt; gt; gt; --Bruce
gt; gt; gt;
gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; gt; gt; with 8 minutes being the up or down trigger.
gt; gt; gt; gt;
gt; gt; gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt; gt; gt;
gt; gt; gt; gt; Any assistance would be appreciated.
gt; gt; gt; gt;
gt; gt; gt; gt; Thank you!
gt; gt; gt; gt; M.

Bruce:

I/WE DID IT. I removed the 24* in the front and it worked prefectly. Thank
you for your assistance!
M.quot;mmockquot; wrote:

gt; Bruce:
gt;
gt; I did the add on, got the foluma to work but it is not calculating properly.
gt; I used a start time on 8:30 and a stop time of 13:38 and it gave me 6 hours.
gt; I changed the stop time to 13:37 and still got 6 hours???
gt;
gt; We are getting there!!
gt; M.
gt;
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; MROUND required the Analysis ToolPak Add-in. On the menu bar Tools gt;
gt; gt; add-ins, select Analysis ToolPak and click OK.
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; HI Bruce:
gt; gt; gt;
gt; gt; gt; Thanks for the reply. Sorry about the delay now, I was away fora few days.
gt; gt; gt; I tried this formula and something I did nust be wrong couse all I get is
gt; gt; gt; #NAME?
gt; gt; gt; I like the theory, maybe you can give me a better example with the start and
gt; gt; gt; end times Ive provided.
gt; gt; gt; Thanks again,
gt; gt; gt; Mark
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;bpeltzerquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; If the start and end times are in B2 and C2, respectively, then
gt; gt; gt; gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; gt; gt; gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; gt; gt; gt; 24 turns the time value into the number of hours).
gt; gt; gt; gt; --Bruce
gt; gt; gt; gt;
gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; gt; gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; gt; gt; gt; with 8 minutes being the up or down trigger.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; gt; gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Any assistance would be appreciated.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thank you!
gt; gt; gt; gt; gt; M.

Hmmm, with the original formula, 8:30 in H12 and 13:37 in H13, I get a result
of 5; with 13:38 in H13 the result is 5.25. Are you entering the times in
the cells that the formula is referencing? What format do you have on the
cell containing the formula (if it doesn't show decimal places, this isn't
going to do much...).

quot;mmockquot; wrote:

gt; Bruce:
gt;
gt; I did the add on, got the foluma to work but it is not calculating properly.
gt; I used a start time on 8:30 and a stop time of 13:38 and it gave me 6 hours.
gt; I changed the stop time to 13:37 and still got 6 hours???
gt;
gt; We are getting there!!
gt; M.
gt;
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; MROUND required the Analysis ToolPak Add-in. On the menu bar Tools gt;
gt; gt; add-ins, select Analysis ToolPak and click OK.
gt; gt;
gt; gt; quot;mmockquot; wrote:
gt; gt;
gt; gt; gt; HI Bruce:
gt; gt; gt;
gt; gt; gt; Thanks for the reply. Sorry about the delay now, I was away fora few days.
gt; gt; gt; I tried this formula and something I did nust be wrong couse all I get is
gt; gt; gt; #NAME?
gt; gt; gt; I like the theory, maybe you can give me a better example with the start and
gt; gt; gt; end times Ive provided.
gt; gt; gt; Thanks again,
gt; gt; gt; Mark
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;bpeltzerquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; If the start and end times are in B2 and C2, respectively, then
gt; gt; gt; gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; gt; gt; gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; gt; gt; gt; 24 turns the time value into the number of hours).
gt; gt; gt; gt; --Bruce
gt; gt; gt; gt;
gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; gt; gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; gt; gt; gt; with 8 minutes being the up or down trigger.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; gt; gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Any assistance would be appreciated.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thank you!
gt; gt; gt; gt; gt; M.

I got a similar question,

Start Time End Time No. of hours
10:30 15:00 4.5
00:00 08:00 8.0
08:00 23:59 16.0

How should i do this?

quot;bpeltzerquot; wrote:

gt; Hmmm, with the original formula, 8:30 in H12 and 13:37 in H13, I get a result
gt; of 5; with 13:38 in H13 the result is 5.25. Are you entering the times in
gt; the cells that the formula is referencing? What format do you have on the
gt; cell containing the formula (if it doesn't show decimal places, this isn't
gt; going to do much...).
gt;
gt; quot;mmockquot; wrote:
gt;
gt; gt; Bruce:
gt; gt;
gt; gt; I did the add on, got the foluma to work but it is not calculating properly.
gt; gt; I used a start time on 8:30 and a stop time of 13:38 and it gave me 6 hours.
gt; gt; I changed the stop time to 13:37 and still got 6 hours???
gt; gt;
gt; gt; We are getting there!!
gt; gt; M.
gt; gt;
gt; gt;
gt; gt; quot;bpeltzerquot; wrote:
gt; gt;
gt; gt; gt; MROUND required the Analysis ToolPak Add-in. On the menu bar Tools gt;
gt; gt; gt; add-ins, select Analysis ToolPak and click OK.
gt; gt; gt;
gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; HI Bruce:
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks for the reply. Sorry about the delay now, I was away fora few days.
gt; gt; gt; gt; I tried this formula and something I did nust be wrong couse all I get is
gt; gt; gt; gt; #NAME?
gt; gt; gt; gt; I like the theory, maybe you can give me a better example with the start and
gt; gt; gt; gt; end times Ive provided.
gt; gt; gt; gt; Thanks again,
gt; gt; gt; gt; Mark
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;bpeltzerquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; If the start and end times are in B2 and C2, respectively, then
gt; gt; gt; gt; gt; =24*MROUND((H13-H12),1/96) should do it. (1/96 because there are 96 quarter
gt; gt; gt; gt; gt; hours in a day, so mround rounds to the nearest quarter hour. Multiplying by
gt; gt; gt; gt; gt; 24 turns the time value into the number of hours).
gt; gt; gt; gt; gt; --Bruce
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;mmockquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I am looking for a formula that can help me calculate hours worked by addiing
gt; gt; gt; gt; gt; gt; start and end times. I would like it to calculate the time by quarter hours
gt; gt; gt; gt; gt; gt; with 8 minutes being the up or down trigger.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Example quot;Downquot; Start at 8:30am - End at 9:37am = 1 hour
gt; gt; gt; gt; gt; gt; Example quot;Upquot; Start at 8:30am - End at 9:38am - 1.25 hours
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Any assistance would be appreciated.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thank you!
gt; gt; gt; gt; gt; gt; M.