negative time values?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

F103=SUM(F94)-(F102)

could someone tell me how to format this cell to get the correct answer,
current format is [h].mm;#;[Red]-[h].mm;
and its giving me a value of 1 and it should be -18:22

F94=218:18
F102=236:40

Thank you,
Steve
 
Try using this format:

[h].mm;[Red]-[h].mm;#;

by default, the second field is for negative numbers, the third for
zero. Yours had negative numbers returning a single digit.
 
Hi Steve

Excel can display negative time with 1904 calendar format (macintosh
calendar) only, see Tools > Options menu somewhere for this setting. In 1900
(windows calendar) she calculates ok but displays just ##########.

So among any ideas is to post Excel version and operating system specs along
with the problem, if you don't mind me saying so.

HTH. Best wishes Harald

Steven said:
anyone have any ideas please?

Steven said:
F103=SUM(F94)-(F102)

could someone tell me how to format this cell to get the correct answer,
current format is [h].mm;#;[Red]-[h].mm;
and its giving me a value of 1 and it should be -18:22

F94=218:18
F102=236:40

Thank you,
Steve
Click to expand...
Click to expand...
 
Thank you Harald your a star! problem sorted, how on earth is someone ment
to know that :P though, i thought excel went ment to be easy to use.

WinXP sp1, Excel 2002 sp2
AMD 2400

Many thanks,
Steve

Harald Staff said:
Hi Steve

Excel can display negative time with 1904 calendar format (macintosh
calendar) only, see Tools > Options menu somewhere for this setting. In 1900
(windows calendar) she calculates ok but displays just ##########.

So among any ideas is to post Excel version and operating system specs along
with the problem, if you don't mind me saying so.

HTH. Best wishes Harald

Steven said:
anyone have any ideas please?

Steven said:
F103=SUM(F94)-(F102)

could someone tell me how to format this cell to get the correct answer,
current format is [h].mm;#;[Red]-[h].mm;
and its giving me a value of 1 and it should be -18:22

F94=218:18
F102=236:40

Thank you,
Steve
Click to expand...
Click to expand...
Click to expand...
 
Harald Staff said:
Excel can display negative time with 1904 calendar format (macintosh
calendar) only, see Tools > Options menu somewhere for this setting. In 1900
(windows calendar) she calculates ok but displays just ##########.

So among any ideas is to post Excel version and operating system specs along
with the problem, if you don't mind me saying so.
Click to expand...

Weird - I just assumedthe OP was using the 1904 date system (on whatever
platform) because he stated the result returned 1. If he'd been using
the 1900 system I'd have thought he'd have gotten the #'s.
 
Back
Top