software

I want to use a calculation that shows time spent at clinic 30 minutes
added for travel time. Once I get the total time (which I already have in
the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot; and
include the hours. If the minutes are gt;30 then I want to round up to the
next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay the
guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic then I
want to pay him 4 hours. I can't figure out how to do this with the If, and
statement to change the time function to a number or do I even need to do
that? Thanks.

=ROUNDUP(A1*48,0)/48

--
Kind regards,

Niek Otten

quot;lschuhquot; gt; wrote in message
...
gt;I want to use a calculation that shows time spent at clinic 30 minutes
gt; added for travel time. Once I get the total time (which I already have in
gt; the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot; and
gt; include the hours. If the minutes are gt;30 then I want to round up to the
gt; next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay the
gt; guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic then I
gt; want to pay him 4 hours. I can't figure out how to do this with the If,
gt; and
gt; statement to change the time function to a number or do I even need to do
gt; that? Thanks.
I put in this formula whereas cell a1 having the 3:12 minutes in it and it
did round up to 3:30 which is great. How would I do this if the minutes
spent at the clinic were gt;=30? Then I would need to make 3:30 to 4 hours.

quot;Niek Ottenquot; wrote:

gt; =ROUNDUP(A1*48,0)/48
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;lschuhquot; gt; wrote in message
gt; ...
gt; gt;I want to use a calculation that shows time spent at clinic 30 minutes
gt; gt; added for travel time. Once I get the total time (which I already have in
gt; gt; the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot; and
gt; gt; include the hours. If the minutes are gt;30 then I want to round up to the
gt; gt; next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay the
gt; gt; guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic then I
gt; gt; want to pay him 4 hours. I can't figure out how to do this with the If,
gt; gt; and
gt; gt; statement to change the time function to a number or do I even need to do
gt; gt; that? Thanks.
gt;
gt;
gt;

=ROUNDUP(A14*48 0.0000000000001,0)/48

--
Kind regards,

Niek Otten

quot;lschuhquot; gt; wrote in message
...
gt;I put in this formula whereas cell a1 having the 3:12 minutes in it and it
gt; did round up to 3:30 which is great. How would I do this if the minutes
gt; spent at the clinic were gt;=30? Then I would need to make 3:30 to 4 hours.
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; =ROUNDUP(A1*48,0)/48
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;lschuhquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I want to use a calculation that shows time spent at clinic 30 minutes
gt;gt; gt; added for travel time. Once I get the total time (which I already have
gt;gt; gt; in
gt;gt; gt; the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot;
gt;gt; gt; and
gt;gt; gt; include the hours. If the minutes are gt;30 then I want to round up to
gt;gt; gt; the
gt;gt; gt; next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay
gt;gt; gt; the
gt;gt; gt; guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic
gt;gt; gt; then I
gt;gt; gt; want to pay him 4 hours. I can't figure out how to do this with the
gt;gt; gt; If,
gt;gt; gt; and
gt;gt; gt; statement to change the time function to a number or do I even need to
gt;gt; gt; do
gt;gt; gt; that? Thanks.
gt;gt;
gt;gt;
gt;gt;
It works fine except if the employee is only at the clinic for 30 minutes.
He gets 30 minutes travel time. Which would give him 1 hour. The second
formula is giving me 30 additional minutes if the employee only spends 30
minutes at the clinic. It shows I should pay 1 hour 30 minutes when I would
only pay 1 hour.
My spreadsheet is set up with
starting time
ending time (the difference between the 2)
the round up, the 2nd roundup
the 30 minutes travel time is something I added in another cell.
I then added the 2 cells together to get actual time travel time.
Is the formula you wrote already adding the 30 minutes travel time? I don't
know what the second formula you put in with all the zeros is doing, but it
works.quot;Niek Ottenquot; wrote:

gt; =ROUNDUP(A14*48 0.0000000000001,0)/48
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;lschuhquot; gt; wrote in message
gt; ...
gt; gt;I put in this formula whereas cell a1 having the 3:12 minutes in it and it
gt; gt; did round up to 3:30 which is great. How would I do this if the minutes
gt; gt; spent at the clinic were gt;=30? Then I would need to make 3:30 to 4 hours.
gt; gt;
gt; gt; quot;Niek Ottenquot; wrote:
gt; gt;
gt; gt;gt; =ROUNDUP(A1*48,0)/48
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Kind regards,
gt; gt;gt;
gt; gt;gt; Niek Otten
gt; gt;gt;
gt; gt;gt; quot;lschuhquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I want to use a calculation that shows time spent at clinic 30 minutes
gt; gt;gt; gt; added for travel time. Once I get the total time (which I already have
gt; gt;gt; gt; in
gt; gt;gt; gt; the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot;
gt; gt;gt; gt; and
gt; gt;gt; gt; include the hours. If the minutes are gt;30 then I want to round up to
gt; gt;gt; gt; the
gt; gt;gt; gt; next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay
gt; gt;gt; gt; the
gt; gt;gt; gt; guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic
gt; gt;gt; gt; then I
gt; gt;gt; gt; want to pay him 4 hours. I can't figure out how to do this with the
gt; gt;gt; gt; If,
gt; gt;gt; gt; and
gt; gt;gt; gt; statement to change the time function to a number or do I even need to
gt; gt;gt; gt; do
gt; gt;gt; gt; that? Thanks.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

I took out the additonal cell with the travel time and just used the 2
formulas you provided and when testing it appears to work ok. I appreciate
your response. If I find something is askew I will write back otherwise
thank you alot.

quot;lschuhquot; wrote:

gt; It works fine except if the employee is only at the clinic for 30 minutes.
gt; He gets 30 minutes travel time. Which would give him 1 hour. The second
gt; formula is giving me 30 additional minutes if the employee only spends 30
gt; minutes at the clinic. It shows I should pay 1 hour 30 minutes when I would
gt; only pay 1 hour.
gt; My spreadsheet is set up with
gt; starting time
gt; ending time (the difference between the 2)
gt; the round up, the 2nd roundup
gt; the 30 minutes travel time is something I added in another cell.
gt; I then added the 2 cells together to get actual time travel time.
gt; Is the formula you wrote already adding the 30 minutes travel time? I don't
gt; know what the second formula you put in with all the zeros is doing, but it
gt; works.
gt;
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt; gt; =ROUNDUP(A14*48 0.0000000000001,0)/48
gt; gt;
gt; gt; --
gt; gt; Kind regards,
gt; gt;
gt; gt; Niek Otten
gt; gt;
gt; gt; quot;lschuhquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I put in this formula whereas cell a1 having the 3:12 minutes in it and it
gt; gt; gt; did round up to 3:30 which is great. How would I do this if the minutes
gt; gt; gt; spent at the clinic were gt;=30? Then I would need to make 3:30 to 4 hours.
gt; gt; gt;
gt; gt; gt; quot;Niek Ottenquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; =ROUNDUP(A1*48,0)/48
gt; gt; gt;gt;
gt; gt; gt;gt; --
gt; gt; gt;gt; Kind regards,
gt; gt; gt;gt;
gt; gt; gt;gt; Niek Otten
gt; gt; gt;gt;
gt; gt; gt;gt; quot;lschuhquot; gt; wrote in message
gt; gt; gt;gt; ...
gt; gt; gt;gt; gt;I want to use a calculation that shows time spent at clinic 30 minutes
gt; gt; gt;gt; gt; added for travel time. Once I get the total time (which I already have
gt; gt; gt;gt; gt; in
gt; gt; gt;gt; gt; the worksheet) I want the total minutes if gt; :01 to round up to quot;30quot;
gt; gt; gt;gt; gt; and
gt; gt; gt;gt; gt; include the hours. If the minutes are gt;30 then I want to round up to
gt; gt; gt;gt; gt; the
gt; gt; gt;gt; gt; next hour. EG: Employee spends 3:12 minutes at clinic. I want to pay
gt; gt; gt;gt; gt; the
gt; gt; gt;gt; gt; guy for 3:30 minutes. If the guy spends 3:31 minutes at the clinic
gt; gt; gt;gt; gt; then I
gt; gt; gt;gt; gt; want to pay him 4 hours. I can't figure out how to do this with the
gt; gt; gt;gt; gt; If,
gt; gt; gt;gt; gt; and
gt; gt; gt;gt; gt; statement to change the time function to a number or do I even need to
gt; gt; gt;gt; gt; do
gt; gt; gt;gt; gt; that? Thanks.
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt; gt;gt;
gt; gt;
gt; gt;
gt; gt;