Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate negative hours in excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate negative hours in excel
hi
the 1900 date system will not show negative time. the 1904 date system will but in switching it will throw off all of your other dates in the file by adding 4 years and 1 day to all dates. tricky situation so it depends on how desperate you are for negative times. Regards FSt1 "suewalton21" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i calculate negative hours in excel
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 |
#4
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 |