I need some help with a formula that will count half days so that I can track expenses for a nanny. I will pay the nanny $40 for each half day that she works. A half day is defined as 1 minute up to 12 hours. At 12 hours and 1 minute it starts a new half day and another $40.
So if the nanny worked 2 days and 6 hours, the cell would show 2.5 days (or 5 half days). Then I can multiply 5 half days times $40 for the total.
I know how to show the time at it is displayed as hh:mm dd/mm/yy.
I also know how to add the start and end cells up to show how many days it is. It usually shows something like 3.2365 days as an example. I would want that to display 3.5
Once I get the correct formula, I can multiply that result with the rate which is $40 a half day for the total.
A1 is (Start Time)
B1 is (End Time)
C1 is (B1-A1) rounded to the next .5 or round number) 6, 6.5, 7,7.5 etc...
Once I can get cell C1 showing the correct half days, I can finish the rest.
Thanks.
Bookmarks