Elapsed time when separate cells contain time and separate date

G

Guest

Have 2 pairs of cells representing two events -- a date and time for each
event stored as text with the date cell in form mm/dd/yyyy and the time cell
in form hh:mm xM. Need to find the elapsed time between the two events in
hours and minutes placed in separate cells.
 
G

Guest

Suppose your cells are arranged like this:
date time
A1 B1
A2 B2

Then enter in cell for hours
=INT(MOD((A2+B2-A1-B1),1)/(1/24))+INT((A2+B2-A1-B1)/1)*24

for minutes
=MOD(MOD((A2+B2-A1-B1),1),1/24)*24*60

Regards,
Stefi


„Gnugs†ezt írta:
 

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

Top