I bill clients and pay contractors to the nearest quarter hour. I cannot seem to put together a formula that will do the job.

say start time is 0800 hrs stop time 1215 hrs. the formula (B-A)/100 returns 4.15   and not the 4.25 needed to calculate pay at the appropriate rate 

but if start time is 0730 hrs and stop time is 1715 the formula (B-A)/100 returns 9.85 and not 9.75 needed

is there a step function i can incorporate? or do I have to create a table and use a look up function? perhaps something simple I haven’t thought of?

​I bill clients and pay contractors to the nearest quarter hour. I cannot seem to put together a formula that will do the job. say start time is 0800 hrs stop time 1215 hrs. the formula (B-A)/100 returns 4.15   and not the 4.25 needed to calculate pay at the appropriate rate  but if start time is 0730 hrs and stop time is 1715 the formula (B-A)/100 returns 9.85 and not 9.75 neededis there a step function i can incorporate? or do I have to create a table and use a look up function? perhaps something simple I haven’t thought of?  Read More

​