Determining number of segments based off time

[volsfan210000]

I have a sheet that I have taken seconds and converted it to minutes. simply took the seconds / 60 to get a number.

Need to determine based off those minutes how many 30 minute increments there are in a given number. For instance 66 minutes would be 3 segments.

Any help would be greatly appreciated.

Thanks!!

 

[mikerickson]

If your 66 is in A1, the formula =Ceiling(A1, 30)/30 should return the number of 30 minute incriments (rounded up).

 

[volsfan210000]

Perfect!!! Thanks!!!