sjvenz
09-08-2005, 04:43 AM
I have the folowing formula
=IF(K21=1,800,IF(K21<1600,K21+800,IF(K21=1600,1,IF(K21>1600,K21-1600))))
What it does is looks at the cell and adds what the value is + 800 which is 8hrs
The problem is that now the powers that be want this addition now to be 8hrs 45mins.
Using the above formula and changing it to
=IF(K21=1,845,IF(K21<1600,K21+845,IF(K21=1600,45,IF(K21>1600,K21-1645))))
This work only on some values
1 = 0845
1600 = 0045
If 0820 is entered then the end result is 1665 when it should be 1705
Does anyone have any ideas about who to get around the 2400 period
=IF(K21=1,800,IF(K21<1600,K21+800,IF(K21=1600,1,IF(K21>1600,K21-1600))))
What it does is looks at the cell and adds what the value is + 800 which is 8hrs
The problem is that now the powers that be want this addition now to be 8hrs 45mins.
Using the above formula and changing it to
=IF(K21=1,845,IF(K21<1600,K21+845,IF(K21=1600,45,IF(K21>1600,K21-1645))))
This work only on some values
1 = 0845
1600 = 0045
If 0820 is entered then the end result is 1665 when it should be 1705
Does anyone have any ideas about who to get around the 2400 period