View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Negative time calculations

And by the way, correct English grammar is Whose site, not who's site (who
is site). :)

Tyro

"Chip Pearson" wrote in message
...
See Chuck Pearson's website (www.cpearson.com) for solutions


Who's site?


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2008
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


"Tyro" wrote in message
.. .
Excel for Windows does not handle negative time calculations. Excel for
Mac does. See Chuck Pearson's website (www.cpearson.com) for solutions

Tyro

"Dave East" <Dave wrote in message
...
I am creating a timesheet requiring negative time to be shown in the
Excel
2007 spreadsheet. I have learnt how to calculate the number of hours
worked
and show how many hours have been worked over the contracted hours.
This
gives a positive value.

The problem appears when the contracted hours exceeds the actual hours.
This would give a negative value but the spreadsheet shows this as a
series
of ############### symbols. It will not show -2 hrs 15 min for example.

Is there a way around this problem, please.