MROUND formula for a Timesheet with break

[symaxf]

Hello Experts!

I have a timesheet that is organized as follows:

Col B = Time In
Col C = Time Out
Col E = Time In
Col F = Time Out
Col G = Total Hrs

I would like Col G to round the Total (Worked) Hrs Up or Down in 15 minute increments (EX: 9:15, 9:30, etc.)
The current formula in Col G is: =ROUND(IF((OR(B13="",C13="")),0,IF((C13<B13),((C13-B13)*24)+24,(C13-B13)*24))+IF((OR(E13="",F13="")),0,IF((F13<E13),((F13-E13)*24)+24,(F13-E13)*24)),2)

Can someone much smarter than me modify this formula to do this?

Thanks in advance!

[FDibbins]

Perhaps this?
=MROUND(M2,15/60/24)

[symaxf]

Thanks Ford. That helps but what I think I need is to combine these two formulas into one and replace it with the formula in Col G:

=MROUND(IF((OR(B13="",C13="")),0,IF((C13<B13),((C13-B13)*24)+24,(C13-B13)*24)-C13/60),15/60)

=MROUND(IF((OR(E13="",C13="")),0,IF((F13<E13),((F13-E13)*24)+24,(F13-E13)*24)-F13/60),15/60)

[symaxf]

Sorry, there was an error in the 2nd formula. I need to combine THESE TWO formulas into ONE:

=MROUND(IF((OR(B13="",C13="")),0,IF((C13<B13),((C13-B13)*24)+24,(C13-B13)*24)-C13/60),15/60)

=MROUND(IF((OR(E13="",F13="")),0,IF((F13<E13),((F13-E13)*24)+24,(F13-E13)*24)-F13/60),15/60)

[Pepe Le Mokko]

Perhaps post a small sample sheet. (see yellow banner)

[symaxf]

File uploaded. Thx!

[Pepe Le Mokko]

It seems the upload didn't work. Did you follow the recommendation of the banner ( don't forget to click the " Upload" button in the wizard, it's not very clear)

[symaxf]

Strange, when I go into manage attachments it shows up with an option to 'remove'.

[symaxf]

I tried uploading the file again, not sure if it was successful.

[symaxf]

Looks like it was!

[symaxf]

So, using the attached sample file what I need is for to round Col G ("Total Hours") up or down to the nearest quarter hour (00, 15, 30, 45). Thx!

[FDibbins]

My suggestion is not working for you because col G does not contain time, it contains regular values. If you dont convert the answers (*24), it should work for you

[symaxf]

FDibbins - Thank you so much for your suggestion! I ended up modifying the existing formula as follows, which seems to be working: =MROUND(IF((OR(B13="",C13="")),0,IF((C13<B13),((C13-B13)*24)+24,(C13-B13)*24))+IF((OR(E13="",F13="")),0,IF((F13<E13),((F13-E13)*24)+24,(F13-E13)*24)),0."25")

[symaxf]

... that last bolded section s/b "0.25"