| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Minutes vs Hours
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
|
|||
|
|||
|
Minutes vs Hours
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Linear Mode
