Roundup time to the nearest 15 minutes.

[milesorru]

Hi

I am stuggling with the following process:

I have 4 durations listed which I have to total together, and then round up to the nearest 15 minutes. The durations appear in a list like this:

Duration</SPAN>

10:06:24</SPAN>

14:41:23</SPAN>

12:00:02</SPAN>

19:17:22</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

The problem is that these are minutes, seconds and frames. The total of this is 56:05:11 which I would need rounded up to 60:00:00.

Is this possible?

Many Thanks in advance

Miles

 

[BenMiller]

Wouldn't 56:05:11 rounded up to the nearest 15 minutes be 56:15:00 ?

But for the results you wanted, with your numbers in A1:A4, try =CEILING(SUM(A1:A4),0.625)

 

[milesorru]

Hi Ben,

to answer your question these are timecodes and so represent themselves as mm:ss:ff.

Your formula; however, worked perfectly

Many Thanks

 

[BenMiller]

Hi Ben,

to answer your question these are timecodes and so represent themselves as mm:ss:ff.

Your formula; however, worked perfectly

Many Thanks

No problem glad to help Appreciate the feedback!

Just a note, Excel looks at them as HH:MM:SS