negative time values?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steven - 12 Apr 2004 16:45 GMT

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

Reply to this Message

JE McGimpsey - 12 Apr 2004 16:53 GMT

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.

> F103=SUM(F94)-(F102)
>
[quoted text clipped - 7 lines]
> Thank you,
> Steve

Reply to this Message

Steven - 12 Apr 2004 17:40 GMT

that returns #########

> F103=SUM(F94)-(F102)
>
[quoted text clipped - 7 lines]
> Thank you,
> Steve

Reply to this Message

Toby Erkson - 12 Apr 2004 19:40 GMT

Expand the column width...

>that returns #########

Toby Erkson
Oregon, USA

Reply to this Message

Steven - 12 Apr 2004 19:10 GMT

anyone have any ideas please?

> F103=SUM(F94)-(F102)
>
[quoted text clipped - 7 lines]
> Thank you,
> Steve

Reply to this Message

Harald Staff - 12 Apr 2004 19:50 GMT

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?
>
[quoted text clipped - 9 lines]
> > Thank you,
> > Steve

Reply to this Message

Steven - 12 Apr 2004 20:21 GMT

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

> Hi Steve
>
[quoted text clipped - 20 lines]
> > > Thank you,
> > > Steve

Reply to this Message

David McRitchie - 13 Apr 2004 22:15 GMT

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

> 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.
[quoted text clipped - 4 lines]
> Many thanks,
> Steve

Reply to this Message

JE McGimpsey - 12 Apr 2004 21:22 GMT

> 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.

Reply to this Message