E
EDDIE
Can anyone give a formula in Excel (MS Office 2000/Windows
NT) for adding together a numeric cell (as in number of
minutes) and h.MM from two cells and producing the answer
in a third cell as hh.mm.
e.. - e22+d22 = e25
where cell e22 is the number of minutes (resultant from
another formula) required to finish a job;
d22 is the time started from i.e. 05.30, and
e25 is the total of both cells i.e. answer required should
therefore show the time taken as - 05.52.
Any advice or help would be much appreciated.
Thanks. Eddie
NT) for adding together a numeric cell (as in number of
minutes) and h.MM from two cells and producing the answer
in a third cell as hh.mm.
e.. - e22+d22 = e25
where cell e22 is the number of minutes (resultant from
another formula) required to finish a job;
d22 is the time started from i.e. 05.30, and
e25 is the total of both cells i.e. answer required should
therefore show the time taken as - 05.52.
Any advice or help would be much appreciated.
Thanks. Eddie