Incorporating Several Formulas into one

  • Thread starter Thread starter simonstevens35
  • Start date Start date
S

simonstevens35

Hi there,
I have a variety of formulas spread over 3 cells. They ar
as follows:


E3 =TEXT(D3-C3,"h:mm")
F3 =((E3-INT(E3))*24)
G3 =ROUNDUP(F3,1).

How would I incorporate these into one large formula, in one cell?

Thanks in advance,

simonstevens3
 
The text part of the formula in E3 is not necessary, you could use

=ROUNDUP(MOD(D3-C3,1)*24,1)

or better

=CEILING(MOD(D3-C3,1)*24,0.1)


--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Back
Top