Time Formula
 

Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only returns
22:00 and I have tried to format it different ways but I never get 31.

What I'm I doing wrong with this or is there another way to do this?

Time Formula
 

Custom format the cell as [hh]:mm then use

=A1+(9/24)

or if integers only

=(A1*24)+9

format as general





--


Regards,


Peo Sjoblom


"Brandon" wrote in message
...
Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only
returns
22:00 and I have tried to format it different ways but I never get 31.

What I'm I doing wrong with this or is there another way to do this?

Time Formula
 

Hey Thanks that work.

Now my schedule is complete.


"Peo Sjoblom" wrote:

Custom format the cell as [hh]:mm then use

=A1+(9/24)

or if integers only

=(A1*24)+9

format as general





--


Regards,


Peo Sjoblom


"Brandon" wrote in message
...
Here is what I have in cell A1 I have this number 22 which is convert from
another cell which is 10 pm and I have tried this =A1+9 but it only
returns
22:00 and I have tried to format it different ways but I never get 31.

What I'm I doing wrong with this or is there another way to do this?