Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative and Positive Time
I have a cell in whic the formula may return a positive time or negative time
depending on the hours worked. I can format the cell to display a positive time or a negative time but not to switch between the 2. I have tried formatting the cell to h:mm;(h:mm) and using the 1904 date system but neither work HELP!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative and Positive Time
Most likely you're calculating time based on a timestamp rather than a
datestamp, and if you subtract a PM hour from an AM hour you will get a negative number (for instance 2 AM - 1 PM = -11, or 2 - 13.. On the other hand if you use a datestamp that includes a fractional portion of a day and format the cells to show time only, you can subtract yesterday's PM time from today's AM time and still get a positive result. In a blank cell in a sprdsht enter =NOW() then format that cell as a number including a comma and several decimal points. 6:30 PM or so yields 38,980.770. You may want to consult Help to read up on serial dates. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative and Positive Time
maybe this will help
=MOD(B1-A1,1) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "DazedandConfused" wrote in message ... I have a cell in whic the formula may return a positive time or negative time depending on the hours worked. I can format the cell to display a positive time or a negative time but not to switch between the 2. I have tried formatting the cell to h:mm;(h:mm) and using the 1904 date system but neither work HELP!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Summing negative time | Excel Discussion (Misc queries) | |||
Negative Time Values | Excel Discussion (Misc queries) | |||
How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) |