I am looking for help with two spreadsheets.
The first one is a timesheet, where i need a formula that will convert start and finish times to 15 minute intervals, however if for example a member of staff clocks in at 6:04 it needs to show 6:15 (3 minutes late is allowed, anything over is docked) The only issue i have at the minute with this formula is the start times can vary between 5:00 and 8:00 and the formula i wrote isnt long enough.
Secondly, i need a formula that will look up multiple cells on different tabs and enter the details onto a main invoice sheet at the front.
this is a work in progress so the spreadsheet can be attached should anybody need to look at what i mean.
Bookmarks