Round Time?

Hi,

I'm worndering how to round time to the nearest 15 minutes or quarter when using this format: 0:00

For example, I have a calculated duration of 1:05 (1 hour & 5 minutes)

How would this be rounded to 1:00 (1 hour)?


Here's the current function I have:

=SUM(P29:P39)
With 0:00 format


Thanks

One way is to use MROUND like this

=MROUND(SUM(P29:P39),"0:15")

although MROUND is an Analysis ToolPak add-in function in Excel 2003 and earlier versions so you could also employ ROUND like this

=ROUND(SUM(P29:P39)*96,0)/96

96 because 0:15 is 1/96 of a day....

Try..

=MROUND(SUM(P29:P39),1/96)

Hi Daddy Long Legs,

The, =ROUND(SUM(P71:P81)*96,0)/96 works great!!

Thanks