Need to add time if value insufficient

Greetings All,

Asking for a bit of formula help for a spreadsheet.

This is the formula that is in use:

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


My issue is if the time values entered do not equate to 30 minutes or more, I am getting a 0 value for time in hours. I need to have at 1 hour billed on Unit 95941 from 1 minute to 30 minutes. At 30, it would round to the next hour, which it currently does.

This is not a common occurrence, but I need to augment the formula to capture time in this situation.


Thank you for your time and help.

Patrick

There are instructions at the top of the page on how to post a sample sheet.Thanks

Here is a stripped down worksheet.


Thanks for the help.