Negative time should be allowed in Excel, eg time difference

B

Bengt-Inge Larsson

If you want to subtract two time values, it shows error if negative.
It would be an interesting feature e.g. for sports.
Also, allow years before 1900 to be shown.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...b-a7b6af37f197&dg=microsoft.public.excel.misc
 
B

Bob Phillips

You cater for it

=IF(A1>B1,A1-B1,B1-A1)

--
HTH

Bob Phillips

Bengt-Inge Larsson said:
If you want to subtract two time values, it shows error if negative.
It would be an interesting feature e.g. for sports.
Also, allow years before 1900 to be shown.


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/com...b-a7b6af37f197&dg=microsoft.public.excel.misc
 
R

Roger Govier

Hi

I think Bob meant
=B1-A1+(A1>B1)*24
assuming Finish Time in B1 and Start time in A1

The formula posted will return 10:00 hours in both cases where A1=23:00
and B1=13:00, and A1=13:00, B1=23:00
as opposed to 14:00 hours and 10:00 hours respectively.

or you could use the less intuitive
=MOD((B1-A1),1)

Regards

Roger Govier
 
Top