Round time maybe this explanation will help

[Darts]

You guys are wonderful

I need to round time
0-0:14 (.23)hrs round down to the full hr.
15 - (.25)hrs and greater needs to be rounded to the next full hour.

7:00am - 8:14am = a total of 1.23hrs I need that to round down the 1.23 hrs
to 1 HR total
7:00am - 8:15am = a total of 1.25 hrs I need that to round up the 1.25 to 2
hrs total


I am woking on this project for my kids school so if you attend the after
school program and you are there for and 1hr and 14 min they charge you for
1hr but if you are there for 1hr and 15 min they charge you for 2hrs

thanks!!!!!!!!!!!!!!!!!!!!!!!!!

[Peo Sjoblom]

If no seconds are involved

=CEILING(B1-TIME(,14,),1/24)



--

Regards,

Peo Sjoblom


"Darts" <u19990@uwe> wrote in message news:5da73488212c8@uwe...
> You guys are wonderful
>
> I need to round time
> 0-0:14 (.23)hrs round down to the full hr.
> 15 - (.25)hrs and greater needs to be rounded to the next full hour.
>
> 7:00am - 8:14am = a total of 1.23hrs I need that to round down the 1.23
> hrs
> to 1 HR total
> 7:00am - 8:15am = a total of 1.25 hrs I need that to round up the 1.25 to
> 2
> hrs total
>
>
> I am woking on this project for my kids school so if you attend the after
> school program and you are there for and 1hr and 14 min they charge you
> for
> 1hr but if you are there for 1hr and 15 min they charge you for 2hrs
>
> thanks!!!!!!!!!!!!!!!!!!!!!!!!!