I have an excel worksheet that calculates my hours into money but i also need help with applying a specific amount of money times (*) it by number of hours between the days Friday 18:30 - Saturday 18:30 (by 24 hours clock only).
the pay is 31.5, pay per minute is 0.525!
so for example, i worked from Friday 10:00 - 19:30, then i get 1 hour at 31.5, the rest isn't important because i have in my worksheet.
and if its 55 minutes that i worked AFTER 18:30 then the pay is for 55 minutes (55*0.525)=28.875!
i attached my worksheet file, so you can look at it.
Bookmarks