time calculations

[lschuh]

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 > :01 to round up to "30" and
include the hours. If the minutes are >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.

[Niek Otten]

=ROUNDUP(A1*48,0)/48

--
Kind regards,

Niek Otten

"lschuh" <[email protected]> wrote in message
news:[email protected]...
>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 > :01 to round up to "30" and
> include the hours. If the minutes are >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.

[lschuh]

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 >=30? Then I would need to make 3:30 to 4 hours.

"Niek Otten" wrote:

> =ROUNDUP(A1*48,0)/48
>
> --
> Kind regards,
>
> Niek Otten
>
> "lschuh" <[email protected]> wrote in message
> news:[email protected]...
> >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 > :01 to round up to "30" and
> > include the hours. If the minutes are >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.
>
>
>

[Niek Otten]

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

--
Kind regards,

Niek Otten

"lschuh" <[email protected]> wrote in message
news:[email protected]...
>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 >=30? Then I would need to make 3:30 to 4 hours.
>
> "Niek Otten" wrote:
>
>> =ROUNDUP(A1*48,0)/48
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "lschuh" <[email protected]> wrote in message
>> news:[email protected]...
>> >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 > :01 to round up to "30"
>> > and
>> > include the hours. If the minutes are >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.
>>
>>
>>

[lschuh]

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.


"Niek Otten" wrote:

> =ROUNDUP(A14*48+0.0000000000001,0)/48
>
> --
> Kind regards,
>
> Niek Otten
>
> "lschuh" <[email protected]> wrote in message
> news:[email protected]...
> >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 >=30? Then I would need to make 3:30 to 4 hours.
> >
> > "Niek Otten" wrote:
> >
> >> =ROUNDUP(A1*48,0)/48
> >>
> >> --
> >> Kind regards,
> >>
> >> Niek Otten
> >>
> >> "lschuh" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >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 > :01 to round up to "30"
> >> > and
> >> > include the hours. If the minutes are >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.
> >>
> >>
> >>
>
>
>

[lschuh]

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.

"lschuh" wrote:

> 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.
>
>
> "Niek Otten" wrote:
>
> > =ROUNDUP(A14*48+0.0000000000001,0)/48
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> >
> > "lschuh" <[email protected]> wrote in message
> > news:[email protected]...
> > >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 >=30? Then I would need to make 3:30 to 4 hours.
> > >
> > > "Niek Otten" wrote:
> > >
> > >> =ROUNDUP(A1*48,0)/48
> > >>
> > >> --
> > >> Kind regards,
> > >>
> > >> Niek Otten
> > >>
> > >> "lschuh" <[email protected]> wrote in message
> > >> news:[email protected]...
> > >> >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 > :01 to round up to "30"
> > >> > and
> > >> > include the hours. If the minutes are >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.
> > >>
> > >>
> > >>
> >
> >
> >