Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Working out a rota....If function or time?
Column A is Names, B is H for Holiday (Mental reminder column) I have column
C (Monday) as a time for a person to work. IE: 09.30 - 12.00. The next column (D) I want to show how many hours that is as in 2.5 etc. Do I use the Time function in C5 and if so what calculates it in D5 for example? There are (As you would expect) the rest of the week similarly shown with a total at the end. If a person works less than 5 hours they don't qualify for a 30min break so I need to show the total in column Q as the weeks hours (Totals of D F H J L N & P) less the various days breaks if they work under the 5 hours. (Shown in C E G I K M O) Occasionally some people work a few days under 5 hours and a few over and I can't decide what function to use to show it all in the correct cells. Can any kind soul assist please because I am going mad trying to figure it out ;-) ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum IF function From time to number not working?? | Excel Worksheet Functions | |||
rota compile | Excel Discussion (Misc queries) | |||
Rota Projection | Excel Discussion (Misc queries) | |||
Work Rota | Excel Worksheet Functions | |||
Rota | Excel Discussion (Misc queries) |