ExcelBanter - View Single Post - I am trying to create a timesheet to work out weekly flexi time.

Hans Terkelsen

"Ranger Nige" <Ranger wrote in message ...
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?

You might try this Custom format in the time cells.
[h]:mm;-[m] \min

The [] parentheses, which are used to display the full value,
solve the negative time problem in a one legged way.
Meaning that [h] can show negative hours and
[m] can show negative minutes.
But one can not get both.

Hans.