Negative and Positive Time

[Guest]

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!!!!!

 

[Dave O]

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.

 

[Bob Phillips]

maybe this will help

=MOD(B1-A1,1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)