Forum Discussion
Barrad0x
Aug 01, 2021Copper Contributor
Error in time of day in formula
Hi all, I need some advice on how to solve this problem please: I’m trying to find a formula that will auto sum a works timesheet where on a Saturday the overtime rates are different from 00:00 (Fr...
- Aug 01, 2021
See the attached sample workbook.
HansVogelaar
Aug 01, 2021MVP
See the attached sample workbook.
- Barrad0xAug 01, 2021Copper ContributorYes Hans - Thats what i needed! you are amazing, thanks! And if i wanted to change the times? say rather than 00:00 to 12:00, maybe 05:00 to 07:30? whats the change in formula?
- HansVogelaarAug 01, 2021MVP
See the attached. If it gets more complicated than this, it would better to change the setup a bit.