User Profile
miscman
Copper Contributor
Joined 4 months ago
User Widgets
Recent Discussions
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 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?493Views0likes3Comments
Groups
Recent Blog Articles
No content to show