View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jayjay Jayjay is offline
external usenet poster
 
Posts: 18
Default Summarising Timesheets

Hi All,

I'm trying to summarise timesheets in a spreadsheet, but having trouble in a
few areas.

We work on flexible time, therefore at the end of the month a timesheet
could have a positive or negative total. These totals need to be carried
forward to the next timesheet so that the person can 'catch up' or go home
early, etc...

I understand that Excel cannot cope with a negative time - any ideas?...

Thank you in advance.

Jayjay

(NB: It would be ok to convert time to decimal, etc as this can be hidden.)