Formula Time calculation 2 variables

Hello All,

I have a worksheet I am trying to get functioning. I could do with some formula assistance please.

My situation:

2 Variables 95941 and G0453

If 95941 is in cell C6 then I need the minute time value in G11 to be converted into nearest rounded full hour

In Cell F12 =calculated value & "Units of 95941


If G0453 is in cell C6 then I need the minute time value in G11 to be converted to nearest rounded 15 min increment

In Cell F12 =calculated value & "Units of G0453


example: G0453 158 minutes in G11
F12= 11 Units of G0453 (rounded up from 10.5)

Thank you for your help,

Patrick

Ahh, John beat me again

Well since I tried to figure this out, I thought I'd post my formula anyway.

In F12:

Please Login or Register  to view this content.

Not near as elegant or expandable...but I tried

Thank you both for your solutions.

I made a few more attempts and this is what I came up with.

=IF(C6="G0453",MROUND(G11/15,1)&" Units of Gcode",MROUND(G11/60,1)&" Units of 95941")

Any pitfalls with this one? Seems to work.


Patrick