R
Robert B Dewsna
I have a formula that I used at school
=IF(MINUTE(B5)<=5,HOUR(B5),IF(MINUTE(B5)<20,HOUR(B5)+0.25,IF(MINUTE(B5)<35,HOUR(B5)+0.5,IF(MINUTE(B5)<50,HOUR(B5)+0.75,HOUR(B5)+1))))
I was asked to change this to read 53 min before hour 7 minuets
after (both showing on time) at 8 min after it goes to a .25 at 21
thru 37 it goes to .50 at 39 thru 52 it goes .75 I hope this is
understandable I want to know what numbers to change in the formula
thank you Rdewsnap
=IF(MINUTE(B5)<=5,HOUR(B5),IF(MINUTE(B5)<20,HOUR(B5)+0.25,IF(MINUTE(B5)<35,HOUR(B5)+0.5,IF(MINUTE(B5)<50,HOUR(B5)+0.75,HOUR(B5)+1))))
I was asked to change this to read 53 min before hour 7 minuets
after (both showing on time) at 8 min after it goes to a .25 at 21
thru 37 it goes to .50 at 39 thru 52 it goes .75 I hope this is
understandable I want to know what numbers to change in the formula
thank you Rdewsnap