Minutes vs Hours

R

RAJ

Hello, please help if you can.

I have a time sheet that is in hours across columns.

User enters start time and end time. Last column
calculates the total hours worked. No problem.

When I sum the hours I get correct total hours.
The problem is, I need to subtract 40 hours from the total
hours worked. I get a nonsense value.

For example, total hours worked is 12. Then 40 - 12 = 12

Please tell me what is wrong. Thanks in advance.
 
C

Chip Pearson

Raj,

Try something like

=TotalTime - (40/24)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Work Budget Salary vs Real Time Salary 0
Macro Challenge – Create Table with Hours Worked and Copy Data 0
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Add Hours by Looping through Data Q 27
Limit to hours in elapsed time format? 2
How to modify and updte specific styles for specific paragraphs across the document 0
SOS-Need to calculate number of working hours per each week of mon 2
I'm sure its an easy answer.... 1

Top