I am trying to create a work spreadsheet that I can input the time our shift starts and ends and a formula to calculate how many hours each person has worked each day. For example:
Start work @ 8:15am
Finish work @ 4.30pm
Total hours worked 8.25 hours worked
The total hours worked has to be worked out so that half an hour is shown as 0.50, fifteen minutes shown as 0.25 etc.
The shifts and hours worked change from day-to-day and week-to-week, so I need to be able to just input the start and finish times and let the spreadsheet work out how many hours have been worked.
Any help would be greatly appreciated.
Michelle x
Bookmarks