Hi,
Wouldn’t dividing by 100 give you the result you want?
Regards,
Martin Gilbert.
______________________________________________________________________________________
Sorry — you’ve probably solved this 15 different ways
I’m just a couple of weeks late and I know you didn’t want to do math
But this equation will round the Input70 to a 5-2 rounded on the quarter hours
QuarterHrs52 = INT(((Input70 / 100) *4 )+ 0.5) / 4
Phil
_______________________________________________________________________________________
Discuss This Question: 6  Replies