Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Raj,
Try something like =TotalTime - (40/24) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "RAJ" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |