Time Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brandon - 26 Oct 2007 18:34 GMT

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?

Reply to this Message

Peo Sjoblom - 26 Oct 2007 18:46 GMT

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

=A1+(9/24)

or if integers only

=(A1*24)+9

format as general

Signature

Regards,

Peo Sjoblom

> 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?

Reply to this Message

Brandon - 28 Oct 2007 20:43 GMT

Hey Thanks that work.

Now my schedule is complete.

> Custom format the cell as [hh]:mm then use
>
[quoted text clipped - 12 lines]
> >
> > What I'm I doing wrong with this or is there another way to do this?

Reply to this Message