"Hi I am trying to work timesheet in any given 7 days period of variable rate Day, Night, Saturday and Sunday rate only have two input example start 22/07/2011 16:00 finish 23/07/2011 04:00 which is 12 hours but night rate kicks in at 18:00 which means in this case 2 hours in day rate and 10 hours in night rate.
Saturday/Sunday rate start and finish 0000 to 2359 I HAVE looked at a few IF/AND statements to separate the different hours from each 24 hour shift to work out hourly rates then add them together to get total but I am faced with brick wall : please help"
Bookmarks