ExcelBanter - IF Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF Function (https://www.excelbanter.com/excel-worksheet-functions/8084-if-function.html)

Frank Fisher

IF Function

I'm working on time schedule worksheet. I would like to subtract 30 minutes
if the hours for that day is 6 or greater. then I would like to subtract 60
minutes if the hours for that is 8 or greater. How do I do this in one cell
with formula in to calculate the total time? Can it be done with the "IF"
function? Thanks

Frank Kabel

Hi
how have you stored your time values?. As Excel time values (format hh:mm)?

--
Regards
Frank Kabel
Frankfurt, Germany

Frank Fisher wrote:
I'm working on time schedule worksheet. I would like to subtract 30
minutes if the hours for that day is 6 or greater. then I would like
to subtract 60 minutes if the hours for that is 8 or greater. How do
I do this in one cell with formula in to calculate the total time?
Can it be done with the "IF" function? Thanks

All times are GMT +1. The time now is 03:55 PM.