Marina L. (job poster) hired David L. (Tasker) to help with this task. Got a similar task you need done?
Open
Assigned
Completed

Excel help

Posted by Marina L.

Location

Bexley, New South Wales, Australia

View map
Due date
Tuesday, 8th May 2018
Details
Need an excel formula to calculate hours worked based on below scenario:
All hours between 7am-4pm at rate A
Any work outside those hours at rate B
Reviews
Marina L. left a review for David L.
“David has worked efficiently and got the requirements of the task right.
Thanks for your help
Regards
Marina”
David L. left a review for Marina L.
“You would think a simple time calculator would be easy. I had to nest 4 layers of formula to account for all scenarios lol.
All hours between 7am-4pm at rate A
Any work outside those hours at rate B
Deduct $ amount by the lunch hours
Notes
1. Hours can be outside/before 7am
2. Break/Lunch can occur anytime so 2 rates apply depending when it's taken.

More than happy to assist. It was fun to work on.
David”
Assignee
David L.
(36)
95%Completion rate

The percentage of accepted tasks this Tasker has completed.

I can do this for you. Please forward me the file once accepting the bid :)
4 months ago
Task Activity
No comment
Comments are now closed
Task Assigned
0 new tasks