displaying formulas

T

TechNoFear

Hi,

I am trying to see a formula and display formulas isn't doing it fo
me

the column changes from
04:40
04:40
04:50
04:40
04:30
04:50
04:50
06:20
04:50
04:50

to

0.194444444444444
0.194444444444444
0.201388888888889
0.194444444444444
0.1875
0.201388888888889
0.201388888888889
0.263888888888889
0.201388888888889
0.201388888888889

which isn't what I expected

the spreadsheet isn't protected and I expected something like

if value > constant then red else green


could someone tell me how to display formulas in this spreadshee
please?



tia
 
D

Dav

The value is just a value and not a formula

times are stored as a fraction of a day so 4:40 = 280minutes out of
total of 1440 minutes and hence as a formula it just shows its value

280/1440=0.194444444444444

Regards

Da
 
B

Bernard Liengme

a) click on a cell and look in the formula bar - do you see a formula?
b) CTRL+~ (the key next to 1 on top row of 'normal' keys) will toggle
display formulas on/off
best wishes
 
B

Bernard Liengme

In these cells you have VALUES such as 0.194444444444444 not FORMULAS
When formatted as time, this value displays 4:40. Note that 0.2 (close to
0.1944...)is 1/5th of a day which is 4 hours and 48 mins. So 0.01944.... is
4:40 AM
best wishes
 
T

TechNoFear

thanks Bernard

in answer to your two questions

a) no
b) no it doesn't, that is how I am toggling between one value and the
other value

I want to see the formula!



tia,
 
R

RagDyeR

If you see only a value in the formula bar when you click in a particular
cell, then you have *NO* formula.

You *only* have data, where varying formats will change the *display* of the
values present.

Are you sure that this data was originally produced by formulas and not by
simple keying in?

Did you perhaps inadvertently remove the formulas and leave the data behind?


--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

in message
thanks Bernard

in answer to your two questions

a) no
b) no it doesn't, that is how I am toggling between one value and the
other value

I want to see the formula!



tia,
 
T

TechNoFear

Hi RD,

if it isn't a formula, then there must be another way of affecting
display.

This particular column is green in colour and empty.

A user types in a value in the format nn:nn i.e, a time like 4:30

If the time is before 05:00 hours, the cell remains green, however, if
the time is later the cell turns red.

I presumed it was a formula, can you tell me how it's done please?


tia,
 
R

RagDyeR

Click in the cell, then:
<Format> <Conditional Formatting>

And you'll see any *formatting* formulas for that cell.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

in message
Hi RD,

if it isn't a formula, then there must be another way of affecting
display.

This particular column is green in colour and empty.

A user types in a value in the format nn:nn i.e, a time like 4:30

If the time is before 05:00 hours, the cell remains green, however, if
the time is later the cell turns red.

I presumed it was a formula, can you tell me how it's done please?


tia,
 
D

David Biddulph

TechNoFear said:
Hi RD,

if it isn't a formula, then there must be another way of affecting
display.

This particular column is green in colour and empty.

A user types in a value in the format nn:nn i.e, a time like 4:30

If the time is before 05:00 hours, the cell remains green, however, if
the time is later the cell turns red.

I presumed it was a formula, can you tell me how it's done please?
Click to expand...

Conditional formatting
 
Top