Rounding For Time

[azbi]

Dear Experts

I have a time calculation, and need to be rounded, could you help me how to round for it as per sample

rounding.xlsx

[Tony Valko]

Like this...

=CEILING((A2+C2)-(A2+B2),30/1440)

Format as h:mm if needed.

[azbi]

Dear Mr. Tony

Almost perfect, but for result that has mention 30 minute, shouldn't be changed (in cell D10)

[Tony Valko]

That particular example is caused by an internal "rounding error". So, you'll have to use double rounding...

=CEILING(ROUND((A2+C2)-(A2+B2),10),30/1440)

[azbi]

Dear Mr. Tonny

Thanks alot, its work

[Tony Valko]

You're welcome. Thanks for the feedback!

[azbi]

Dear Mr. Tony

Sorry to ask again, there's one problem again, if result of the calculation is one hour, using that formula become 1 hour and 30 minute, could it be corrected?

[samba_ravi]

D2=TIME(HOUR(C2-B2),CEILING(MINUTE(C2-B2),30),)

Please Login or Register  to view this content.

Try this and copy towards down

[azbi]

Dear nflsales

Correct, and works..