Excel 97 - formatting time formula results

[pwilliams]

In column B I have a range of time in minutes and seconds (time format mm:ss.0) and the same in column C, Column D = C - B, if the answer is positive value then it formats fine, however if it is negative excel returns #############... I have even managed to get excel to turn the #### red indicating a negative value.

Any ideas anyone?

Thanks,
Pete

 

[paulovey]

Hi,

You may need to create a custom type.

In Format / Cells. Select custom from the catagory list.

Apart from that, good luck.

Paul

 

[pwilliams]

Paul,

thanks for the suggestion, already tried that which is how i got the red ####... although i'm the first to admit i may have got the format slightly wrong.

cheers,
Pete

 

[Dreamboat]

Looks like you can't have negative time. But you can still do it in hours by =(B1-A1)*24 and formatted as numbers with 2 decimals.
techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[Dreamboat]

PS: Really terrific site, 'specially for time stuff:

http://www.cpearson.com/excel/topic.htm

techsupportgirl@home.com
Brainbench MVP for Microsoft Word

http://www.brainbench.com

 

[pwilliams]

Thanks for the site... i am sure it'll come in very handy at work!

Pete