Need formula to calculate meal penalties

how are the times entered ?

=IF( D13<12 , 0, IF( AND(D13>=12, D13<=30), 1, roundup(D13/30 , 0 )))

This is not correct - but the sort of thing you probably need

But need to see how the numbers are entered

Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Hi Calc,

Welcome to the forum.

Assuming you have your value in cell A1 then try the following formula in B1.

Formula:

Please Login or Register  to view this content.

Let me know if this solve your purpose.

Cheers!!

Anil Dhawan

=IF(D13<=12,0,CEILING(D13/30,1))
Try this

Thanks for adding Reputation "Calc7827 "

Thanks for adding reputation Calc.

Cheers!!!!