Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |