I would like to be able to auto-populate a column with a time value depending on the value in another.
For example, Column H runs a total of hours worked... 8:30, 4:00, 9:00 etc and I would like column I to autocalculate to remove 30 mins if that number is over 6 hours.
I have:
=arrayformula(if(H2:H<6/24,H2:H,H2:H-1/48))
But this just gives me #NAME?
Bookmarks