hi all, i have a simple staff rota, where hours are entered as 17:00-22:00 format, which denotes 5 hours. i need to be able to enter data from monday to sunday, which will calculate the amount of hours in each shift, and yield total hours at the end of the week, which is on a sunday. it should be able to ignore fields which are marked "off", to denote a day off, and highlight this cell red. I also have a possibility where the times will be logged as 17:00 to finish, so i will require to create a custom time which will have a value for times such as these. as always, any help appreciated.! x