Thread
:
Negative time calculations
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_]
external usenet poster
Posts: 1,091
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.
Reply With Quote
Tyro[_2_]
View Public Profile
Find all posts by Tyro[_2_]