HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi was wondering can anyone help
E=mround(c3,(1/24/60)*15)
F=mround(d3,(1/24/60)*15)
G=median("07:00","23:00",if(f3<e3,1+f3,f3))-median("07:00","23:00",e3)
this is for time worked on a shift to calculate wages, i would like to be able to take .45 min off of the calculation but only after 8.75 as min 8 hours before break is deducted.
can the current cell be modified or do I need to make a new calculation in a new cell to achieve this
Any help gratefully received
E=mround(c3,(1/24/60)*15)
F=mround(d3,(1/24/60)*15)
G=median("07:00","23:00",if(f3<e3,1+f3,f3))-median("07:00","23:00",e3)
this is for time worked on a shift to calculate wages, i would like to be able to take .45 min off of the calculation but only after 8.75 as min 8 hours before break is deducted.
can the current cell be modified or do I need to make a new calculation in a new cell to achieve this
Any help gratefully received