A
adc
Hello
I am trying to create a spread sheet that the user can put in there time and it will total the total hours owed then what is regular , overtime and double time. I have been able to put in the start time of 7:00 am and Finish 4:30 pm less lunch. I have the total hours but I can't figure out how to get the total hours to be pull into the cell as regular which is 8 hours or less and anything over 8 hours but less than 12 and anything over 12. If anyone has an idea has to what I can do I would greatly appreciate your help
Thanks
adc
I am trying to create a spread sheet that the user can put in there time and it will total the total hours owed then what is regular , overtime and double time. I have been able to put in the start time of 7:00 am and Finish 4:30 pm less lunch. I have the total hours but I can't figure out how to get the total hours to be pull into the cell as regular which is 8 hours or less and anything over 8 hours but less than 12 and anything over 12. If anyone has an idea has to what I can do I would greatly appreciate your help
Thanks
adc