We are in the construction sector. We have a number of sites with varying numbers of men on each.
Currently we have a timesheet for each which carries forward ( sort of ) to a summary page, which is then used for paying the wages.
Problem we have is getting the timesheet to calculate properly on a 24 hr clock. If we have say someone starting at 0700hrs to 1800hrs less 30min break we want the excel spreadsheet to calculate the time worked and then do a summary over the 7 days of total hours worked. We run in to particular difficulties when someone starts at 2000hrs and finishes at 0400hrs for example.
Happy to make out current system available to give a clearer picture -- see below. Names have been changed
English to Indonesian Translation Services Category: English (UK) Translator, English (US) Translator, Indonesian Translator, Traditional Chinese (Hong Kong), Translation Budget: $10 - $30 USD