HappyChappy
Active Member
- Joined
- Jan 26, 2013
- Messages
- 378
- Office Version
- 2019
- 2010
- 2007
- Platform
- Windows
Hi have this formula =(G6*24)*$A$43 it refers to a start time and a finish time ie: 07:00 and 13:00 then it multipies it by A43 the amount per hour.
I want it to round to 8 hours pay as a minimum so if someone worked 8.45 or less it would be 8:00
Any help with this
many thanks
I want it to round to 8 hours pay as a minimum so if someone worked 8.45 or less it would be 8:00
Any help with this
many thanks