negative time values?

[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

 

[JE McGimpsey]

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.

 

[Steven]

that returns #########

 

[Steven]

anyone have any ideas please?

 

[Toby Erkson]

Expand the column width...

that returns #########

Toby Erkson
Oregon, USA

 

[Harald Staff]

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

anyone have any ideas please?

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

 

[Steven]

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

WinXP sp1, Excel 2002 sp2
AMD 2400

Many thanks,
Steve

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

anyone have any ideas please?

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

 

[JE McGimpsey]

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.

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.

 

[David McRitchie]

You still want to use colons for time instead of periods
[h]:mm;[Red]-[h]:mm;#;