Time / Negative Time


K

Kiaat

Hi,

If, for instance, in Excel you write 17:00 - 16:30, it will produc
0:30. However, 16:30 - 17:00 will produce #####, understandibly
because you cannot have - ? o'clock. By formatting this to a number
can produce -0.5.

What if I still want to represent the decimal, but out of 60, so that
can still get -0.30. I have tried messing about with fractions and
still can't get it. Any ideas?

Thanks,
 
Ad

Advertisements

R

Ron Rosenfeld

Hi,

If, for instance, in Excel you write 17:00 - 16:30, it will produce
0:30. However, 16:30 - 17:00 will produce #####, understandibly,
because you cannot have - ? o'clock. By formatting this to a number I
can produce -0.5.

What if I still want to represent the decimal, but out of 60, so that I
can still get -0.30. I have tried messing about with fractions and I
still can't get it. Any ideas?

Thanks,

K
1. Format as time and change to the 1904 date system. That will give you
-0:30

Tools/Options/Calculations Workbook Options Select 1904 Date System

2. Use this formula:

=(A2-A1)*24*60/100 or =(A2-A1)*14.4 and format as General



--ron
 
Ad

Advertisements

D

Dave Peterson

If you change:

Tools|options|calculation tab
and enable "1904 date system"

You can see negative times--but watch your dates. You'll be off by 4 years and
one day.

Or you could see it as text:

=IF(A1<B1,"-","")&TEXT(ABS(B1-A1),"hh: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

Negative Time 7
negative times. 1
Negative Time Calculation 3
Displaying a negative time 3
negative time values? 8
Excel Negative Time Format 8
DIsplaying negative time values 1
Showing negative 'Times' in cells. 1

Top