formula for interpreting time cards with .25-.50-.75

  • Thread starter Thread starter Robert B Dewsna
  • Start date Start date
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
 
Hello Robert

I think that this is what you want

=IF(MINUTE(B15)<=7,HOUR(B15),IF(MINUTE(B15)<21,HOUR(B15)
+0.25,IF(MINUTE(B15)<37,HOUR(B15)+0.5,IF(MINUTE(B15)
<52,HOUR(B15)+0.75,HOUR(B15)+1))))

Regards
Peter
 
Back
Top