hi i have the following formula in cell f4 on a sheet
=B10-F5-F6-F7-F8-F9-F10-F11-F12-F13-F14-F15-F16-F17-F18-F19-F20-F21-F22-F23-F24-F25-H4-H5-H6-H7-H8-H9-H10-H11-H12-H13-H14-H15-H16-H17-H18-H19-H20-H21-H22-H23-H24-H25
which i thought i could shorten to something like:
=B10-(F4:F25)-(H4:H25)
but its throwing an error - any help appreciated. the cells are time values
=B10-F5-F6-F7-F8-F9-F10-F11-F12-F13-F14-F15-F16-F17-F18-F19-F20-F21-F22-F23-F24-F25-H4-H5-H6-H7-H8-H9-H10-H11-H12-H13-H14-H15-H16-H17-H18-H19-H20-H21-H22-H23-H24-H25
which i thought i could shorten to something like:
=B10-(F4:F25)-(H4:H25)
but its throwing an error - any help appreciated. the cells are time values