Menu

I am trying to create a timesheet to work out weekly flexi time.

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Hans Terkelsen Hans Terkelsen is offline

Hans Terkelsen is offline

external usenet poster

Posts: 31

Default

I am trying to create a timesheet to work out weekly flexi time.

"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.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create a timesheet to add daily and weekly hours and overtime	molemo	Excel Worksheet Functions	1	July 26th 06 08:03 AM
Weekly Timesheet help	Diane	New Users to Excel	3	February 12th 06 05:05 PM
How to set up weekly time sheet with flexi time.	Chris	Excel Worksheet Functions	0	June 9th 05 02:30 AM
Is there a weekly timesheet for excel somewhere?	dan	Excel Discussion (Misc queries)	2	April 30th 05 02:05 PM
Flexi Time	Parlo	New Users to Excel	1	January 16th 05 02:05 PM

All times are GMT +1. The time now is 12:16 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement