| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate negative hours in excel
Sorry but that does not give me a negative number Here is a copy
25:40 24:00 1:40 28:35 28:00 0:35 31:35 32:00 0:25 31:35 36:00 #### "David Biddulph" wrote: If you have 20 in A1 and 16 in A2, the formula =A2-A1 will give you a negative result. If that isn't what you want, you'll need to be more specific with your question. -- David Biddulph "suewalton21" wrote in message ... I have a staff time sheet which calculates hours worked It also calculates additional hours worked How do I get it to show minus hours worked eg usual cumulative hours = 20 actual cumulative hours =16 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate hours without negative | Excel Worksheet Functions | |||
| Calculate negative hours (time) | Excel Worksheet Functions | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
Hybrid Mode
