lcastanheiro
New Member
- Joined
- Feb 21, 2019
- Messages
- 9
- Office Version
- 365
- Platform
- Windows
Hi, I am trying to automate a time sheet to log man-days based on the hours worked. The timesheet has start and stop time, based on which calculates the hours worked and it should return the value in man-days based on the following condition:
How do I elegantly do that?
Thanks for your help.
Work : | log as: | |
Less or equal to 2 hrs. | 0.00 | days |
3 hrs | 0.25 | days |
4 hrs | 0.50 | days |
5 hours | 0.75 | days |
More than 6 but less than 10 hrs. | 1.00 | days |
11 Hours | 1.25 | days |
12 hours | 1.5 | days |
13 hours | 1.75 | days |
14 hours | 2 | days |
How do I elegantly do that?
Thanks for your help.