adding time and splitting the answer
Hi,
For hours
=A1/(24*60)
format as [hh]
for minutes
=MOD(A1,60)
format as general
Mike
"ramona" wrote:
Is it possible to add time (minutes) and come up with a total of hours and
minutes BUT then put the total number of hours in one cell and the left over
minutes in a different cell? I thought I sent this before but can't find it
nor did I ever receive an email back. If it's been answered, I'm sorry. But
perhaps it cannot be done? (We use Excel 2003.)
|