=ROUNDUP(A1*48,0)/48

--
Kind regards,

Niek Otten

"lschuh" wrote in message
...
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.