adding time and splitting the answer

  • Thread starter Thread starter ramona
  • Start date Start date
R

ramona

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.)
 
Hi,

For hours

=A1/(24*60)
format as [hh]

for minutes
=MOD(A1,60)
format as general

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding Hours 1
Adding Times 3
Time calculation or formula 6
IF,AND and OR 2
Adding Time 1
Need help calculating time 8
dividing a number into hours and minutes 1
why is answer rounded up? 1

Back
Top