LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ejerry7
 
Posts: n/a
Default Subtracting paid hours from unpaid hours

Hi,

I made a simple timesheet that keeps track of my hours and is set up to go
past the 24 hr mark. What I want to do is subtract my paid hours from my
unpaid hours. So if I have 25:15:00 total hours minus 10:00:00 paid hours it
should come out to 15:15:00 unpaid hours. Total hours is cell G33 with the
formula =SUM(G5:G32), total paid hours is cell G35 with the format of
9/12/2004 10:00:00 AM, and total unpaid hours is cell G37 with the formula
of =G33 - TIME(10,0,0).

What I want is a formula so that all I have to do is change the "Paid hours"
(G35), number and the "Unpaid hours" (G37), will change automatically. See
my timesheet at http://www.misscarlasbbq.com/timesheet.htm Any help would be
greatly appreciated.

Thanks in advance,
Jerry
 
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
Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 3 November 15th 04 05:17 PM


All times are GMT +1. The time now is 07:22 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"