Forum Discussion
CALCULATING 24 HOUR TIME TO THE NEAREST QUARTER HOUR
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 ...
Your question is not clear. Can you show a screenshot of your data then show what output do you want? Why you are dividing by 100 to find a quarter?