Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
JDB JDB is offline
external usenet poster
 
Posts: 42
Default Deficit Hours

Hi,

I have a time sheet that needs to record extra hours worked or time taken
off. I've got it all to work fine, except I can't get excel to recognise
deficit hours. For example, if a person works 7hrs of a 7.5 hour day, I need
to show that they've had .5 hour off. Half hour chunks are the minimum time
that anyone can record as extra work or take off as time owed.

Jason.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis Graham Excel Discussion (Misc queries) 2 January 28th 07 08:40 PM
how to add hours and show actual hours not decimal numbers TWERNER New Users to Excel 2 August 21st 06 08:35 AM
i need to make a formula that adds up my hours after my 40 hours johnny rodriguez Excel Discussion (Misc queries) 5 October 26th 05 05:03 AM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 04:19 PM
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"