View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ranger Nige Ranger Nige is offline
external usenet poster
 
Posts: 1
Default I am trying to create a timesheet to work out weekly flexi time.

I have downloaded a template (Weekly timesheet with breaks) from Excel to
work out my flexi-time. However I am having difficuties in getting answers
in hours and minutes i.e.
Morning 08:30 to 12:30
Lunch 12:30 to 13:24
Afternoon 13:24 to 16:30
should equate to 7 hours 9minutes (Standard working day)
5 days at these hours = 35 hours 45minutes (Standard working week)
if I work more or less than these times I want to be able to see individual
hours & minutes plus being able to carry forward from one week to the next?