Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spread sheet that I use for time comparisons on a project. There
are target and actual times that get compared. I want to be able to show the resulting difference as a positive or negative value. For example: Target Time: 9:00 AM Actual Time: 9:01:25 AM I would like to be able to show tha result as + 01:45 I also need to account for the other situation as well: Target Time: 9:00 AM Actual Time: 8:58:25 AM I would like thsi result to show as - 01:35 Any help would be most appreciated. I can definitely get the calaulation to run ok, but I have not yet found a way to format the result in the desired fashion. dknorwood |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I display negative time values in excell? | Excel Worksheet Functions | |||
entering negative time values in excel | Excel Discussion (Misc queries) | |||
Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
Negative Time Values | Excel Discussion (Misc queries) |