negative time

[jps1957]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

How can I get a negative time displayed, if this is possible

Example

A1 = 04:00 (formatted as uu:mm)
A2 = 05:00 (formatted as uu:mm)
A3 = A1-A2 = should result in -01:00 (in red ? ) (formatted as uu:mm)

I want to make a timetable of worked hours (pos or neg)

Thanks for response, JP

 

[CyberTaz]

Well, anything is possible if you're willing to go to the extent necessary
to make it happen Quite often, however, there may be another way.

One option is illustrated in Excel Help: Calculate the number of hours and
minutes between two times, but this renders a text result.

I think the problem, though, may be with the format you're using. Unless you
have a non-English version of Excel the proper format is h:mm ‹ I've never
seen "uu:mm" used before. The result I get here (based on your example data)
is -1:00, but the red font color would have to be applied by Conditional
Formatting. What result are you actually seeing? If something different, is
your Office software fully updated?

In your example what do these numbers actually represent & what are you
specifically trying to derive as a result of the subtraction? You're right ‹
there is no such thing as "negative" time... How can anyone work fewer than
0 seconds? If you can clarify your objective there are most likely several
possibilities even if it means approaching from a different direction.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Bob Greenblatt]

Well, anything is possible if you're willing to go to the extent necessary
to make it happen Quite often, however, there may be another way.

One option is illustrated in Excel Help: Calculate the number of hours and
minutes between two times, but this renders a text result.

I think the problem, though, may be with the format you're using. Unless you
have a non-English version of Excel the proper format is h:mm ‹ I've never
seen "uu:mm" used before. The result I get here (based on your example data)
is -1:00, but the red font color would have to be applied by Conditional
Formatting. What result are you actually seeing? If something different, is
your Office software fully updated?

In your example what do these numbers actually represent & what are you
specifically trying to derive as a result of the subtraction? You're right ‹
there is no such thing as "negative" time... How can anyone work fewer than
0 seconds? If you can clarify your objective there are most likely several
possibilities even if it means approaching from a different direction.

Regards |:>)
Bob Jones
[MVP] Office:Mac

PMFJI Bob, but you do not need conditional formatting fro this. Just use the
format string: h:mm;-[red]h:mm

 

[Laroche J]

Why not use a format like hh:mm;[Red]hh:mm (or uu:mm;[Red]uu:mm) ? It works
perfectly for me. If you want both a negative sign AND the numbres in red,
then use hh:mm;[Red]-hh:mm (or uu:mm;[Red]-uu:mm).

Bob, you cannot work less than 0 second, but you can still work less than
the expected work time, which you could consider negative time. ;>)

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 12.1.latest



CyberTaz wrote on 2009-07-13 14:54:

 

[CyberTaz]

By Golly, that never even crossed my feeble old mind ‹ I haven't done much
with custom formats in a few years & answered in to much of a hurry I
guess that's why you get the BIG BUCK$ ;-)

Regards |:>)
Bob Jones
[MVP] Office:Mac

Well, anything is possible if you're willing to go to the extent necessary
to make it happen Quite often, however, there may be another way.

One option is illustrated in Excel Help: Calculate the number of hours and
minutes between two times, but this renders a text result.

I think the problem, though, may be with the format you're using. Unless you
have a non-English version of Excel the proper format is h:mm ‹ I've never
seen "uu:mm" used before. The result I get here (based on your example data)
is -1:00, but the red font color would have to be applied by Conditional
Formatting. What result are you actually seeing? If something different, is
your Office software fully updated?

In your example what do these numbers actually represent & what are you
specifically trying to derive as a result of the subtraction? You're right ‹
there is no such thing as "negative" time... How can anyone work fewer than
0 seconds? If you can clarify your objective there are most likely several
possibilities even if it means approaching from a different direction.

Regards |:>)
Bob Jones
[MVP] Office:Mac

PMFJI Bob, but you do not need conditional formatting fro this. Just use the
format string: h:mm;-[red]h:mm

 

[JE McGimpsey]

PMFJI Bob, but you do not need conditional formatting fro this. Just use the
format string: h:mm;-[red]h:mm

PMFJI to your JI, but it's also good to remember that this only works in
the 1904 date system...