I have a table and I am doing a time calculation in
Column A
Mgr Adjustments
60
30
450
0
0
50
65
Column B
Formula =A6*1/60 ----this converts the value in column A to increments of time clock time (.25, .5, etc) But when the number in that column is value of 450, I don't want this to calculate, and instead return a zero result.
I need to add in an IF function that will ignore any of the entries that value 450, and the result would be Zero instead of 7.5
help!
Bookmarks