Time Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Hey Thanks that work.

Now my schedule is complete.


Peo Sjoblom said:
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 said:
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?
Click to expand...
Click to expand...
 
Back
Top