negative time values?


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
 
Ad

Advertisements

J

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

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

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
 
Ad

Advertisements

S

Steven

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
 
J

JE McGimpsey

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

Advertisements

D

David McRitchie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DIsplaying negative time values 1
Negative Time 7
Time / Negative Time 2
Negative value 1
negative times. 1
Negative Time Calculation 3
Displaying a negative time 3
Negative value in Excel 1

Top