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.